SQL Remote User's Guide
Tutorials for Adaptive Server Anywhere Users
Tutorial: Adaptive Server Anywhere replication using Interactive SQL and dbxtract
Set up the remote database
To load the database information
From the tutorial directory, connect to the remote database field.db from Interactive SQL with a user ID of DBA and a password of SQL.
Run the reload.sql command file:
READ C:\tutorial\reload.sql
The reload.sql command file carries out the following tasks:
Creates a message type at the remote database.
Grants PUBLISH and REMOTE permissions to the remote and consolidated database, respectively.
Creates the table in the database. If the table had contained any data before extraction, the command file would fill the replicated table with a copy of the data.
Creates a publication to identify the data being replicated.
Creates the subscription for the consolidated database, and starts the subscription.
While connected to the field database as DBA, confirm that the tables are created by executing the following statements:
SELECT * FROM SalesRep ; SELECT * FROM Customer ;
The system is now ready for replication.
For the next step, inserting and replicating data, see the section Start replicating data .