Saturday, February 25, 2012

2005 to 2000 Replication

Can you setup a Transactional Replication from SQL Server 2005 database to a
SQL Server 2000 database?
If not, what else can be done to move data to a 2000 database (data
warehouse, about 10 tables)?
Thanks and God Bless,
ThomBeaux
Provided the distributor is 2005 also then it is possible. Please see this
page for details of supported mixes:
http://msdn2.microsoft.com/en-us/library/ms143241.aspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

No comments:

Post a Comment