Sybase SQL Remote DC38133-01-0902-01 User Manual
Chapter 9. Deploying and Synchronizing Databases
and uses large numbers of locks. Also, the subscriptions must be started at
the same time that the copy is made. Any operations that take place between
the copy and the starting of the subscriptions would be lost, and could lead
to errors at remote databases.
the same time that the copy is made. Any operations that take place between
the copy and the starting of the subscriptions would be lost, and could lead
to errors at remote databases.
Extracting groups
If the remote user is a group user ID, the extraction utility extracts all the
user IDs of members of that group. You can use this feature to all multiple
users on each remote database, using different user IDs, without requiring a
custom extraction process.
user IDs of members of that group. You can use this feature to all multiple
users on each remote database, using different user IDs, without requiring a
custom extraction process.
When a database is extracted for a user, all message link parameters for that
user and the groups of which the user is a member are extracted.
user and the groups of which the user is a member are extracted.
Limits to using the extraction utility
While the extraction utility is the recommended way of creating and
synchronizing remote databases from a consolidated databases, there are
some circumstances where it cannot be used, and you must synchronize
remote databases manually. This section describes some of those cases.
synchronizing remote databases from a consolidated databases, there are
some circumstances where it cannot be used, and you must synchronize
remote databases manually. This section describes some of those cases.
♦
Cannot create Adaptive Server Enterprise remote databases
The
extraction utility can only be used for Adaptive Server Anywhere remote
databases.
databases.
♦
Additional tables at the remote database
Remote databases can have
tables not present at their consolidated database as long as these tables do
not take part in replication. Of course, the extraction utility cannot extract
such tables from a consolidated database.
not take part in replication. Of course, the extraction utility cannot extract
such tables from a consolidated database.
♦
Adaptive Server Enterprise/Adaptive Server Anywhere differences
Some features in Adaptive Server Enterprise are not present in Adaptive
Server Anywhere. The extraction utility carries out a mapping onto
similar features, but the mapping is not complete.
Server Anywhere. The extraction utility carries out a mapping onto
similar features, but the mapping is not complete.
☞
For more information on Adaptive Server Enterprise/Adaptive Server
Anywhere issues, see
♦
Extracting procedures and views
By default, the extraction utility
extracts all stored procedures and views from the database. While some
of these views and procedures are likely to be required at the remote site,
others may not be required—they may refer only to parts of the database
that are not included in the remote site.
of these views and procedures are likely to be required at the remote site,
others may not be required—they may refer only to parts of the database
that are not included in the remote site.
After running the extraction utility, you should edit the reload script and
remove unnecessary views and procedures.
remove unnecessary views and procedures.
195