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

    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
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Are you looking to create a warm standby database in case of a failure in the primary database?

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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.

    -PatP
    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
  •