Creating a Database Replication Definition

Create a database replication definition.

1. Navigate to the $SYBASE/RAX-15_5/scripts/sybase (UNIX or Linux) or %SYBASE%\RAX-15_5\scripts\sybase (Windows) directory.
2. Make a copy of the rs_create_test_db_repdef.sql script named my_rs_create_db_repdef.sql.

   cp rs_create_test_db_repdef.sql
   my_rs_create_db_repdef.sql

3. Before executing the my_rs_create_db_repdef.sql script, change all occurrences of {pds}.{pdb} to the name of the connection string you defined for the primary database, where:

   • pds is the name of the primary Oracle server.

   • pdb is the primary Oracle System ID (SID).

   For example, NY.NYora92.

   Note:

   Save these values to be used later for the rs_source_ds and rs_source_db parameters in the Replication Agent oracle.rs file.

   This is a database replication definition example:

   create database replication definition NY_repdef1

   with primary at NY.NYora92

   replicate DDL

   go

4. Connect to the Replication Server and enter:

   isql -Usa -P –SSAMPLE_RS -i my_rs_create_db_repdef.sql

   You see a message indicating that the database replication definition has been created.