Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Replication Setup on 2 Versions of SQL Server

Author  Topic  kwilliams 194 Posts Posted - 2003-11-05 : 10:30:10 Hello, We are trying to set up replication between different versions of SQL Server (7 & 2000). This is how the 2 servers are now setup: DB1 - External web-server w/SQL Server 7 DB2 - Internal server w/SQL Server 2000 REPLICATION SETUP This is how we need the replication to be set up. They are all Transactional Replications. DISTRIBUTION: This is set up on DB2, which is running on 2000 WITH PUBLISHERS ON DB1, AND PULL SUBSCRIPTIONS ON DB2: dbo.Employment_App & dbo.Employ_Jobs (together in one replication) dbo.Feedback NOTE: This set of replications work some of the time, but make DB1 & DB2 very slow when running. A lot of times, the jobs say "Retrying Job", but they usually will eventually work. WITH PUBLISHERS AND PUSH SUBSCRIPTIONS ON DB2: dbo.Jobs dbo.Releases dbo.Search NOTE: This set of replications used to work when DB1 & DB2 both ran on SQL Server 7 with 2000 Enterprise Manager's. But since we moved the data to an internal server (DB2) that runs on 2000, it doesn't work at all. We've researched the problem, and found an article by MS called "Replication Between Different Versions of SQL Server" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replimpl_4joy.asp that states that this setup should be possible (on Combination 3 for Transactional Replications). But it's not working at all. Are there some steps that we need to check to have replication setup between 2 servers running on different versions of SQL Server (7 & 2000)? Any & all help & advice is appreciated. Thanks. KWilliams