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.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0