Before you begin setting up the replication system, you should be familiar with the Microsoft SQL Server data server and have an understanding of Sybase replication. In addition, these conditions must be met:
ECDA for ODBC is installed on the same host as your standby Microsoft SQL Server database.
You have obtained the licenses for the Replication Server and Mirror Activator.
Microsoft SQL Server 2005 SP2, with database compatibility set to 2005(90), is installed and configured to serve as the target (standby) database and as the source (primary) database, from which Mirror Replication Agent replicates transactions. There must also be a user with permissions to log in to the standby database.
Microsoft SQL Server JDBC driver 1.2 is installed.
TCP/IP connectivity is available.
Mirror Replication Agent has direct access to the Microsoft SQL Server online transaction logs or a mirrored copy of those logs.
During this procedure:
Because Mirror Replication Agent for Microsoft SQL Server is limited to the Microsoft Windows platform, all examples shown are for Windows.
On Windows Vista, you must be logged in as an Administrator.
Sybase recommends that you do not use Replication Server reserved words for object names and connection names. A complete list of reserved words are documented in Chapter 2 of the Replication Server Reference Manual.
