Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Remote » SQL Remote Administration » Deploying and synchronizing databases with SQL Remote » Using the Extraction utility (dbxtract)

 

Before extracting a database

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