All geek questions in one place

Is SQL Server the equivalent of MySQL multi-trunk replication?

Is there MSSQL equivalent to MySQL multi-trunk replication? If so, is this possible in SQL Express 2008? I also saw that this is called two node circular replication.

Basically, I have an internal database in which I want to be completely (relatively :)) in sync with the cloud database (we will have access via VPN). Read and write occurs on both nodes.

+4
source share
4 answers

Peer-to-peer transactional replication . It is the only Enterprise feature. Another option is a renewable transactional replication subscription, see Renewable Subscriptions for Transactional Replication . And finally, you can use your own Service Broker , which is the only option that will work with the Express client, unless the “cloud” edition is express.

+7
source

SQL Server 2008 Enterprise and Standard offerings offer:

SQL Server 2008 Express has limited functionality with

In both cases, you need to write an individual solution.

There is an excellent chapter in SQL Server MVP Deep Dives called “Poor Man SQL Server Log Shipping”. He will guide you through the whole process.

+4
source

When you say cloud database, do you mean SQL Azure? If so, Azure SQL does not support replication.

If your cloud database is a full copy of SQL Server (i.e. not express), you can set up transactional publishing with renewable subscriptions or use merge publishing. Both options allow you to synchronize changes in any database.

Edit

To clarify, you can use SQL Server Express for replication, but only as a subscriber. The publisher must be a Workgroup editor or higher.

+1
source

In addition to what others have published, I would also mention merge replication and the MSDN article on Choosing the Right Replication Type . In principle, regardless of whether you choose a union or a transaction (with updating subscribers), it depends on how much of the records are on different nodes and the likelihood of inconsistent changes.

0
source

Source: https://habr.com/ru/post/1313966/

More articles:


All Articles