MSSQL Synchronisation - question

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

MSSQL Synchronisation - question

Author

Topic

topsy11
Starting Member

1 Post

Posted - 2012-05-16 : 11:09:46

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!

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-05-16 : 11:17:43

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources