File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Synchronize two databases (MS SQL 2005) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Synchronize two databases (MS SQL 2005)" Watch "Synchronize two databases (MS SQL 2005)" New topic

Synchronize two databases (MS SQL 2005)

Renjith Mohan
Ranch Hand

Joined: Nov 28, 2008
Posts: 65

I have similar MSSQL database running in different servers. They differ only in the amount of data. I want to synchronize them.

How can I achieve?

Thanks in advance
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33102

First step is to define synchronize. I can think of a few things you might be trying to do:
1) Copy all the data from one to another wiping out anything existing
2) Add all the data from one to another leaving existing data
3) Do a row by row compare and add the data to the database that doesn't have it yet

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Synchronize two databases (MS SQL 2005)
It's not a secret anymore!