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:
-
The Publisher and Distributor must be the same version. Choose either 6.0 or 6.5 for both Publisher and Distributor.
-
Replication administration must be done from SQL Enterprise Manager on a SQL Server 6.5.
-
You must install the SQLOLE65.SQL script on the 6.0 server involved in replication. To install SQLOLE65.SQL, run the script for your platform found on the SQL Server CD-ROM. From the SQL Server CD-ROM, choose the subdirectory for your platform, and then choose the subdirectory for ODBC. The correct script resides in the ODBC subdirectory.
-
When replicating from a SQL Server 6.0 server to a SQL Server 6.5 server, the replication process works as a SQL Server 6.0 replication process. The enhanced replication features of SQL Server 6.5 will not be available. For more information about SQL Server 6.0 replication, see the Microsoft SQL Server Administrator's Companion for 6.0.
-
When replicating from a SQL Server 6.5 server to a SQL Server 6.0 server, the SQL Server 6.0 server is treated as an ODBC server. You must set up a data source name (DSN) for the SQL Server 6.0 server.
To set up the SQL Server 6.0 server as a DSN:
-
On the machine where SQL Server 6.5 resides, from the Main program group, click Control Panel.
-
From Control Panel, run the ODBC Administration application, and add the subscriber's DSN as a system DSN.
-
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.
-
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.
-
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.