Filter
Top Products
When used from Sybase Central, the extraction utility carries out the
database unloading task, in the same way that
dbxtract
does, and then takes
the additional step of creating the new database.
The extraction utility does not use a message system. The reload file
(
ssxtract
/
dbxtract
) or database (from Sybase Central) is created in a
directory accessible from the current machine. Synchronizing many
subscriptions over a message link can produce heavy message traffic and, if
the message system is not completely reliable, it may take some time for all
the messages to be properly received at the remote sites.
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.
☞ For a description of how to carry out these steps, see the tutorial in the
chapter “Tutorials for Adaptive Server Anywhere Users” on page 27. For a
description of setting message link parameters, see “Setting message type
control parameters” on page 214.
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.
Using the extraction utility from Sybase Central
This section describes how to extract a database for a remote user from the
current consolidated database. This section applies only to Adaptive Server
Anywhere consolidated databases.
When you complete the Extract Database wizard, it does the following on
your machine:
♦ Creates the remote database
192