All the components of your replication system must be properly installed and configured before you can begin replication.
Use the following checklist to verify that your replication system is set up.
Create (or identify) the primary objects (tables or stored procedures) in the primary database.
Create (or identify) the replicate objects (tables or stored procedures) in the replicate database.
In the primary Replication Server (the Replication Server that controls the primary database), create a replication definition for each primary object (table or stored procedure) to be replicated.
In the replicate Replication Server (the Replication Server that controls the replicate database), create subscriptions for the replication definitions that were created in the primary Replication Server.
If the primary Replication Server is not the same as the replicate Replication Server, you must create routes between them.
Materialize each primary table in the replicate database so that the contents of the replicate database are synchronized with the primary database.
Create the Replication Agent transaction log objects in the primary database.
Mark and enable replication for the primary objects (tables or stored procedures) for which you want to replicate transactions from the primary database.
Start the Replication Agent instance and use the resume command to begin scanning the transaction log and sending LTL to the primary Replication Server.
Actual LTL output from the Replication Agent to the primary Replication
Server does not occur until replicated transactions are captured
in the primary database.
Sybase Replication Agent provides test scripts that automate these and other setup procedures for testing purposes (in a test environment). You can use the test scripts to verify the basic setup and configuration of your Sybase replication system.
For more information about Replication Agent test scripts, refer to the appropriate appendix in this book for your primary database server:
