Replicating between SQL Server 6.0 and SQL Server 6.5

SQL Server 6.5 supports replicating between 6.0 and 6.5 SQL Servers. Before setting up replication between servers of different versions, consider the following constraints:

    To set up the SQL Server 6.0 server as a DSN:
  1. On the machine where SQL Server 6.5 resides, from the Main program group, click Control Panel.
  2. From Control Panel, run the ODBC Administration application, and add the subscriber's DSN as a system DSN.
  3. Using SQL Enterprise Manager, configure the newly added system DSN as a subscribing server to the publishing server by choosing the New Subscriber button from the Replication - Publishing dialog box.

    The New Subscriber dialog box appears.

  4. From the New Subscriber dialog box, choose the ODBC Subscriber button.
    Complete the New ODBC Subscriber dialog box that appears.

    Note Only system DSNs are listed in the New ODBC Subscriber dialog box.

  5. While using SQL Enterprise Manager to create or edit a publication, perform a push subscription to the subscriber by choosing the Subscribers button from the Edit Publications or Edit Article dialog box.

    Complete the dialog box that appears.