Applying transactions on two databases

• v_krishnan

  Say Hey Kid

  Points: 676

  More actions

  August 14, 2003 at 5:33 am

  #82213

  I have a requirement where certain changes that I make to a database are to be updated on to another database which has the same tables, etc. I have a problem that if one of the databases is down, then how do I remember my changes so that can I apply it on the other database when it comes up? Is there a possibility to copy a portion of the transaction log on the basis of time (or something else) and then apply it on to the other database? Is there any built-in mechanism in SQL server for handling such cases?

• Ferguson

  SSCertifiable

  Points: 5837

  More actions

  August 14, 2003 at 6:02 am

  #469906

  I use the Red-Gate compare program and periodically compare our numerous databases to see if they are the same.

  No matter what tricks you use to try to remember, sometimes you will forget. This lets you find those quickly.

  PS. I have no connection to the company other than as a satisfied user.