Before you begin setting up the replication system, be familiar with the Microsoft SQL Server data server and have an understanding of Sybase replication. In addition:
ECDA for ODBC must be installed on the same host as your replicate Microsoft SQL Server database.
Replication Agent must be installed on the same host as your primary Microsoft SQL Server database.
You have obtained the licenses for the Replication Server and Replication Server Options.
Microsoft SQL Server 2005 SP2, with database compatibility set to 2005(90), must be installed and configured to serve as the source (primary) database and as the target (replicate) database from which Replication Agent replicates transactions.
Microsoft SQL Server JDBC driver 1.2 must be installed.
TCP/IP connectivity must be available.
During this procedure:
Because Replication Agent for Microsoft SQL Server is limited to the Microsoft Windows platform, all examples shown are for Windows.
On Windows Vista and Windows Server 2008, 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 is in the Replication Server Reference Manual.
