Replicating test data

The following commands assume that you set up the MARKET_INDEX table for replication.

1. Using isql from a command prompt, insert data into the ASE source table:

   insert into MARKET_INDEX values
       (10,'Test1','Test1','Test1','2005-10-18')
   go
   insert into MARKET_INDEX values
       (20,'Test2','Test2','Test2','2005-10-18')
   go
   insert into MARKET_INDEX values
       (30,'Test3','Test3','Test3','2005-10-18')
   go
   

2. Log into the target IQ database using Interactive SQL (dbisql) to select data from the target table using the following SQL statement. Verify that the data was replicated properly:

   commit;
   select * from MARKET_INDEX
   

3. Using isql from a command prompt, insert data into the ASE source table:

   update MARKET_INDEX
       set INDEX_NAME='Update Test'
       where MARKET_INDEX_ID=20
   go
   delete MARKET_INDEX
       where MARKET_INDEX_ID=30
   go
   

4. Use Interactive SQL for IQ (dbisql) and select data from the target table using the following SQL statement. Verify the data was replicated properly:

   commit;
   select * from MARKET_INDEX
   

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF