This week's book giveaway is in the Agile forum.
We're giving away four copies of The Software Craftsman and have Sandro Mancuso on-line!
See this thread for details.
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

Win a copy of The Software Craftsman this week in the Agile forum!
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: 31668

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]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Have you tried LearnNowOnline?
subject: Synchronize two databases (MS SQL 2005)