Replication between SQL 7 and 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 29 Oct 2006 17:21 GMT

Hi i need to know how would it be possible to configure SQL 2005 and 7 to
replicate with each other.

SQL 7 will need to be the publisher and SQL 2005 will be the subscriber. SQL
2005 will not update back any data to SQL 7 but just read the changes made
and store it into the sql 2005 database.

Is this only done via scripting because i cant get the either enterprise
manager or the SQL Management studio to talk to each other.

Reply to this Message

Hilary Cotter - 29 Oct 2006 20:17 GMT

It should work, you will probably need to create the SQL 2005 server as an
ODBC subscriber.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi i need to know how would it be possible to configure SQL 2005 and 7 to
> replicate with each other.
[quoted text clipped - 5 lines]
> Is this only done via scripting because i cant get the either enterprise
> manager or the SQL Management studio to talk to each other.

Reply to this Message

Paul Ibison - 30 Oct 2006 10:51 GMT

Assuming the distributor is SQL Server 7.0 or SQL Server 2000 this should be
fine (see http://msdn2.microsoft.com/en-us/library/ms143241.aspx).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Reply to this Message