SQL Remote User's Guide
Tutorials for Adaptive Server Anywhere Users
Tutorial: Adaptive Server Anywhere replication using Sybase Central
The remote database needs to be created and configured in order to send and receive messages and participate in a SQL Remote setup.
Like the consolidated database, the remote database needs a publisher (in this case, the field_user user ID) to identify the source of outgoing messages, and it needs to have hq_user identified as a user with consolidated permissions. It needs the SalesRepData publication to be created and needs a subscription created for the hq_user user ID.
The remote database also needs to be synchronized with the consolidated database; that is, it needs to have a current copy of the data in order for the replication to start. In this case, there is no data in the publication as yet.
The database extraction utility enables you to carry out all the steps needed to create a remote database complete with subscriptions and required user IDs.
You need to extract a database from the consolidated database for remote user field_user.
To extract a database
Connect to the HQ database.
Right-click the database and choose Extract Database from the popup menu.
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.
Leave the reload file location at its default setting and choose to extract both structure and data.
Leave the location to save the data at its default value.
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.
The system is now ready for replication.
For the next step, inserting and replicating data, see the section Start replicating data.