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?
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.