Replicating test data

The following commands reference 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-02-18')
   

   go
   

            insert into MARKET_INDEX values
   

     (20,'Test2','Test2','Test2','2005-02-18')
   

   go
   

            insert into MARKET_INDEX values
   

     (30,'Test3','Test3','Test3','2005-02-18')
   

   go
   

2. Log into the target IQ database using Interactive SQL 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. Using Interactive SQL for IQ 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