aspose file tools
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
Author

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
Renjith
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31433
    
184

Renjith,
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Synchronize two databases (MS SQL 2005)