KWilliams75
Programmer
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
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