Sybase DC38133-01-0902-01 manual Extracting groups, Limits to using the extraction utility

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.

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.

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.

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.

♦ Cannot create Adaptive Server Enterprise remote databases The extraction utility can only be used for Adaptive Server Anywhere remote 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.

♦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.

☞ For more information on Adaptive Server Enterprise/Adaptive Server Anywhere issues, see “Using the extraction utility for Adaptive Server Enterprise” on page 196 .

♦ 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.

After running the extraction utility, you should edit the reload script and remove unnecessary views and procedures.

195