Replication Between SQL 6.5 & 7.0

[Andel]

Here's the setup:

SQL 6.5 - Publisher/Distributor
SQL 7.0 - Subscriber

Books Online says I could do this but I just don't know how. The prolem is I can't do pull subscription. When I run the subscription wizard in sql7, it ask for a registered servers. But I can't register a 6.5 to sql7 server. Have anybody done this before?

Andy
Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[Qaroven]

Haven't exactly tried that either, but have tinkered with it between SQL 7 DBs .. from memory it needed a Linked Server or Remote Server to be set up (in the Security section in SQL 7). Never did it using EM personally cos it continually crashed, but think in SQLBOL under sp_addlinkedserver or similar should have something.

BTW I'm just guessing that it won't have a problem linking to 6.5 DBs. Ben
+61 403 395 052