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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replication Between Different Versions of SQL Server

Status
Not open for further replies.

KWilliams75

Programmer
Nov 5, 2003
1
US
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 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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top