| Author |
Best method to re-loading users
|
|
|
| In the upgrade to my application I do the following steps:
1)Unload all user data from original database
2)Replace the original database with the new database
3)Reload the user data back into the new database
At the moment this upgrade requires the DBA to manually relplace the users
into the upgrades database.
What is the best method of extracting all the user information from the
original database to automatically load into the new database.
Thanks
TPS
| |
| Chris Keating \(iAnywhere Solutions\) 2005-04-11, 8:24 pm |
| Wouldn't it be easier to unload/reload the existing schema (aka the original
database) and make any necessary schema changes in the new database?
"TPS" <ts@scientexlc.com> wrote in message news:425abf7e$1@foru
ms-1-dub...
> In the upgrade to my application I do the following steps:
> 1)Unload all user data from original database
> 2)Replace the original database with the new database
> 3)Reload the user data back into the new database
>
> At the moment this upgrade requires the DBA to manually relplace the users
> into the upgrades database.
>
> What is the best method of extracting all the user information from the
> original database to automatically load into the new database.
>
> Thanks
> TPS
>
| |
| Breck Carter [TeamSybase] 2005-04-12, 7:23 am |
| Dbunload.exe builds a reload.sql script that probably contains all the
commands you need to reconstruct users.
Breck
On 11 Apr 2005 11:18:38 -0700, "TPS" <ts@scientexlc.com> wrote:
>In the upgrade to my application I do the following steps:
>1)Unload all user data from original database
>2)Replace the original database with the new database
>3)Reload the user data back into the new database
>
>At the moment this upgrade requires the DBA to manually relplace the users
>into the upgrades database.
>
>What is the best method of extracting all the user information from the
>original database to automatically load into the new database.
>
>Thanks
>TPS
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
|
| A little more detail. The user data resides in 7 database tables and is
about 1 - 10% of the total data. Support data (static information) resides
in aroung 150 database tables. Thus it is not efficient in the vast majority
of our users to unload make schema changes reload the support data.
We have several 1000 database's and the upgrades are done automatically
through an upgrade applications. The majority of users do not know what
sybase central or ISQL are. Most of the databases are single user database
thus the need to reload users is not necessary. My issue is the several
dozen multi-user databases we need to remotely add the users or spend an
hour or 2 on the phone stepping someone through the steps to accomplish
this.
Is it not possible to select the user data from the system tables and store
it into tempory files than reload this information back in the new database?
If it is which tables do I need to unload?
Thanks
TPS
"Chris Keating (iAnywhere Solutions)" < Spam_NoThanks_keatin
g@iAnywhere.com>
wrote in message news:425ac671$1@foru
ms-1-dub...
> Wouldn't it be easier to unload/reload the existing schema (aka the
> original database) and make any necessary schema changes in the new
> database?
>
>
> "TPS" <ts@scientexlc.com> wrote in message news:425abf7e$1@foru
ms-1-dub...
>
>
| |
| Chris Keating \(iAnywhere Solutions\) 2005-04-13, 9:23 am |
| Look at the syntax that is used by the dbunload and use that syntax to
rebuild the users. Use SYSUSERPERM to collect the necessary information.
select user_name, password from SYS.SYSUSERPERM
"TPS" <ts@scientexlc.com> wrote in message news:425c3d40$1@foru
ms-1-dub...
>A little more detail. The user data resides in 7 database tables and is
>about 1 - 10% of the total data. Support data (static information) resides
>in aroung 150 database tables. Thus it is not efficient in the vast
>majority of our users to unload make schema changes reload the support
>data.
>
> We have several 1000 database's and the upgrades are done automatically
> through an upgrade applications. The majority of users do not know what
> sybase central or ISQL are. Most of the databases are single user database
> thus the need to reload users is not necessary. My issue is the several
> dozen multi-user databases we need to remotely add the users or spend an
> hour or 2 on the phone stepping someone through the steps to accomplish
> this.
>
> Is it not possible to select the user data from the system tables and
> store it into tempory files than reload this information back in the new
> database? If it is which tables do I need to unload?
>
> Thanks
> TPS
>
>
> "Chris Keating (iAnywhere Solutions)"
> < Spam_NoThanks_keatin
g@iAnywhere.com> wrote in message
> news:425ac671$1@foru
ms-1-dub...
>
>
|
|
|
|