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/de...limpl_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