Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replication between 2000 and 7.0

Status
Not open for further replies.

LuvASP

Programmer
May 18, 2000
46
US
Does SQL Server 2000 support replication to a 7.0 database. My source database resides on a SQL Server 2000 box and the destination database resides on a SQL Server 7.0 box.
Will the replication work?

Thanks.
 
Short answer yes. 2000 can replicate to almost any database that is OLE/DB compatible, which SQL 7 obviously is. You may have some implementation specific issues, for example the Bigint data type is new to SQL 2000, obviously there would be an issue replicating a table that included that data type to 7. If you provide more details we can provide more answers.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top