• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Synchronizing a database with SQL 2000 and SQL 2008 across a WAN

We have SQL 2000 at our office and SQL 2008 at a data center.  The sites are connected via a VPN between two PIX firewalls.

I have one database that needs to be shared between the two.  The users at the office insert the records and users on a web application hosted at the data center update the records.  The updated records need to go back to the office server which uses them to update a seperate database that is only used locally at the office.

Is this a situation for merge replication or bidirectional transactional replication?  Is bidirectional transactional replication even possible with a mix of SQL 2000 and SQL 2008?  Am I overlooking a different solution?
  • 2
1 Solution
You've stated your requirement; but you've not said what latency you can deal with; i.e. the data needs to be sent within 1/10/60/+ mins...

Not sure how happy Bidirectional Transactional would be with the different versions; Would need to look into any issues with replicating to different versions and possibly editions.

fairoakianAuthor Commented:
I really dislike the idea of anything that isn't immediate or nearly immediate.  I have one DTS job that runs hourly and I could never get the users to grasp the concept.  That said, reliability and consistency need to take preference if it comes to that.
fairoakianAuthor Commented:
The suggestion to look into version differences rendered my question moot as we're using the workgroup edition at the collocation.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now