By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,422 Members | 1,615 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,422 IT Pros & Developers. It's quick & easy.

Replication Between Different Versions of SQL Server

P: n/a
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
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Just to follow up on this - I'd be very interested to know if anyone has
successfully got a replication to work with 6.5 as the publisher /
distribution and MSDE (7 or 2000) as the subscriber?

Thanks

Chris Gadsby
"KWilliams" <we*******@douglas-county.com> wrote in message
news:e9**************************@posting.google.c om...
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

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.