Solved

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

Posted on 2009-04-14
3
215 Views
Last Modified: 2013-11-30
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?
0
Comment
Question by:fairoakian
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
St3veMax earned 250 total points
ID: 24145675
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.

HTH
0
 

Author Comment

by:fairoakian
ID: 24150029
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.
0
 

Author Closing Comment

by:fairoakian
ID: 31570250
The suggestion to look into version differences rendered my question moot as we're using the workgroup edition at the collocation.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now