Replicating data

Transact-SQL® is the language used in Adaptive Server databases for querying, adding new data, modifying existing data, and deleting existing data. Transact-SQL is described in the Adaptive Server Enterprise Transact-SQL User’s Guide as pubs2 and pubs3 databases. You must use Transact-SQL commands in the following example.

To verify that replication is occurring:

  1. Log in to the primary database, and, using Transact-SQL commands, add, alter, or delete information in one or more of the primary database tables.

  2. Log in to the replicate database and confirm that your changes have been replicated.