SQL Script to sync. two servers

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sqldba
    New Member
    • Dec 2007
    • 8
    #1

    SQL Script to sync. two servers

    Hi,

    I have two servers, one is a production server and other is a testing server. Both these servers must be in sync.

    Please can anyone let me know how to synchronize these two servers(automat ically) without replication.

    In particular i want databases, tables, views, users and stored procedures to be same in both the servers. If a table gets added/deleted/update on the production , the same must be done on testing server.

    Please help on doing this. Can you please help me in writing the script to backup all databases and restore it across network.

    Please give a best solution.

    Thanks in advance
    Tags: None
    • radcaesar
      Recognized Expert Contributor
      • Sep 2006
      • 759
      #2
      The one and only way you have is transactional replication. Why don't you prefer replication?

        Comment

        • Anand Naphade
          New Member
          • Feb 2010
          • 1
          #3
          You are right..
          Replication is the best way to Synchronize Two servers..

            Comment

            • sashi
              Recognized Expert Top Contributor
              • Jun 2006
              • 1749
              #4
              how to synchronize these two servers(automat ically) without replication
              Look at database mirroring option. Since you have 2 server, your production server can play the role of principal while your testing server can be the mirror.

              All you need to do is create snapshot of the mirrored database to view the mirroring result.

                Comment

                Previous template Next
                Working...