Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2012

    Question Unanswered: how do I syncrhronize to MS SQL DATABASES

    is there anything in MS SQL Server that works like the rsync command used in linux with oracle dbs? I need to keep SQL server dbs synchronized continously. How can I accomplish this?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    Are you looking to create a warm standby database in case of a failure in the primary database?

  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    If you want to synchronize Microsoft SQL Servers with each other, then there are several options. The closest option to rsync that SQL Server provides is Snapshot Replication. Depending on your needs, Transaction Replication might be more appropriate.

    Because the files used by Microsoft SQL Server don't naturally quiesce while SQL Server is running, a simple "snatch and run" solution like rsync doesn't work.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts