• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Synchronize two databases (MS SQL 2005)

 
Renjith Mohan
Ranch Hand
Posts: 65
Android Chrome Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Posts: 35269
383
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic