aspose file tools*
The moose likes JDBC 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

Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
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: 31054

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

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Synchronize two databases (MS SQL 2005)