locked
synchronize and compare two database in real time RRS feed

  • Question

  • how to synchronize and compare two database in sql server 2000 without using any others software in real time.

    my purpose is to check the two database in two different server if there has any different. And synchronize these two database continusly.

    if one database had change, the other will also change

    Thursday, September 7, 2006 4:25 AM

Answers

  • Hi odinlai,

    I think you are asking two questions.

    1) synchronize two database continously. SQL server replications provides transactional replication and merge replication. Both are able to keep two database in sync continously. You might want to check Books Online to evaluate the right technology for you.

    2) compare two databases. Do you mean to compare the data in the tables/views of two databases? SQL Server 2005 provides a tools called tablediff.exe that can compare the data for you. For more information, you can check BOL (http://msdn2.microsoft.com/en-us/library/ms162843.aspx)

    Peng

    Monday, September 18, 2006 8:54 PM

All replies

  • I am moving the post here so that it gets the right attention.  Did you try using Merge Replication between two SQL Servers so that you dont need to worry about syncing them time to time.  There are many parameters in Merge Replication, which I think would make the things in real time.

    Thanks,

    Laxmi

    Monday, September 18, 2006 7:22 PM
  • Hi odinlai,

    I think you are asking two questions.

    1) synchronize two database continously. SQL server replications provides transactional replication and merge replication. Both are able to keep two database in sync continously. You might want to check Books Online to evaluate the right technology for you.

    2) compare two databases. Do you mean to compare the data in the tables/views of two databases? SQL Server 2005 provides a tools called tablediff.exe that can compare the data for you. For more information, you can check BOL (http://msdn2.microsoft.com/en-us/library/ms162843.aspx)

    Peng

    Monday, September 18, 2006 8:54 PM