Solved

Toad for SQL Server synchronization problem

Posted on 2014-10-20
3
144 Views
Last Modified: 2014-11-05
Hi Experts

I need assistance with synchronizing the databases that we have across three servers.  The current process that we have is rather tedious (backup-restore) and was hoping for a more automated way of doing it.  We have Toad for SQL Server (v6.5) that according to their documentation, would allow one to compare/sync databases across different servers, however, can't get it to work.

Any assistance would be greatly appreciated
0
Comment
Question by:devguru001
  • 2
3 Comments
 
LVL 48

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40393811
I never used TOAD or another 3rd tool for manage my SQL Server instances and databases.
Until now SQL Server Management Studio was very good to do everything I need.
For databases synchronization you have some solutions as Replication, Log Shipping, Mirroring or Snapshot depending on what is the purpose.
0
 

Author Closing Comment

by:devguru001
ID: 40423570
Hi

My apologies for responding after so much time.  

I have looked into mirroring and seems to be a working solution.  I also saw that Microsoft recommends that it not be used as a solution for new development (don't really understand why) and will look into other means of achieving this.

Thanks again!
0
 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 40423579
I also saw that Microsoft recommends that it not be used as a solution for new development (don't really understand why)
That's because it's already deprecated in SQL Server 2014. Since SQL Server 2012 that the new feature AlwaysOn can be used for mirroring.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question