User's Manual

Chapter 4. Tutorials for Adaptive Server Anywhere Users
You need to extract a database from the consolidated database for remote
user field_user.
❖ To extract a database
1. Connect to the HQ database.
2. Right-click the database and choose Extract Database from the popup
menu.
3. Choose to extract the HQ database with the following options:
♦ Choose to extract at isolation level 3.
♦ Choose to Start Subscriptions Automatically, for user field_user.
♦ Choose Extract and Reload into a New Database.
♦ Leave the reload file location at its default setting.
♦ Choose to extract both structure and data.
♦ Choose not to extract fully-qualified publication definitions.
♦ Create the database as file c:\tutorial\field.db , and click Finish to create
the remote database.
In a proper SQL Remote setup, the remote database field would need to be
loaded on to the computer using it, together with an Adaptive Server
Anywhere server and any client applications required. For this tutorial, we
leave the database where it is and use Interactive SQL to input and replicate
data.
You should connect to the field database as DBA and confirm that all the
database objects are created. These include the SalesRep and Customer
tables, the SalesRepData publication, and the subscription for the
consolidated database.
What next? The system is now ready for replication.
☞ For the next step, inserting and replicating data, see the section “Start
replicating data” on page 47.
39