SQL Remote User's Guide
Deploying and Synchronizing Databases
Using the extraction utility
You must complete the following tasks before using the extraction utility at a consolidated database.
Create message types for replication.
Add a publisher user ID to the database.
Add remote users to the database.
Add the publication to the database.
Created a subscription for the remote users.
If you need to specify message link parameters, you must have set them.
For a description of how to carry out these steps, see the tutorial in the chapter Tutorials for Adaptive Server Anywhere Users. For a description of setting message link parameters, see Setting message type control parameters.
When you use the extraction utility to create a remote database, the user for which you are creating the database receives the same permissions they have in the consolidated database. Further, if the user is a member of any groups on the consolidated database, those group IDs are created in the remote database with the permissions they have in the consolidated database.