Contents Index Extract the remote database information Start replicating data

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

Load the remote database information

To load the database information

  1. 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.

  2. Run the reload.sql command file:

    READ C:\tutorial\reload.sql

The reload.sql command file carries out the following tasks:

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 ;
What next? 

The system is now ready for replication.

For the next step, inserting and replicating data, see the section Start replicating data .


Contents Index Extract the remote database information Start replicating data