SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 MSSQL Synchronisation - question		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

topsy11
Starting Member

1 Posts
Posted - 05/16/2012 :  11:09:46  Show Profile  Reply with Quote
Hello, I hope this is the right place to post the thread, if not please excuse me! I would like to ask how to synchronise 2 MSSQL databases on separate servers, so that when you change something in #1, the changes take place in #2 as well. MSSQL #1 is linked to a website, however MSSQL #2 will be on a separate server and it will not be accessible via the website. What needs to be done in this case?

Hope I managed to explain what I mean. If you need any clarification do let me know!
Thanks very much!
Edited by - topsy11 on 05/16/2012 11:14:54

robvolk
Most Valuable Yak

USA
15567 Posts
Posted - 05/16/2012 :  11:17:43  Show Profile  Visit robvolk's Homepage  Reply with Quote
In SQL Server you have quite a few options:

- Replication: http://msdn.microsoft.com/en-us/library/ms151198.aspx
- Log Shipping: http://msdn.microsoft.com/en-us/library/ms187103.aspx
- Database Mirroring: http://technet.microsoft.com/en-us/library/cc917680.aspx
- Always On Availability Groups (SQL 2012): http://msdn.microsoft.com/en-us/library/ff877884.aspx
- Microsoft Sync Framework: http://msdn.microsoft.com/en-us/sync/bb736753

There are also options using Service Broker, Change Data Capture, and third-party products that can replicate data.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000