Sybase DC38133-01-0902-01 manual Select * from SalesRep Select * from Customer

♦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 ;

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 .

46