CodePudding user response:
Take some synchronization function is essentially itself, such as: copy subscription, log shipping, mirror, alwayson.At present the most advanced, the most useful is alwayson, https://blog.csdn.net/yenange/article/details/46495661
But you have to cross the context, and network transmission quality can't guarantee, is also difficult,
Third party has a Golden gate, is said to be very good, you can try:
http://www.talkwithtrend.com/Article/31695
CodePudding user response:
Key is a network problem, SQL server comes with synchronization tool,CodePudding user response:
SQL Server comes can realize data synchronization, the features of the CDC source table change information in the form of a timestamp sequence record alone in the shadow of the corresponding table, just put the shadow in the table data is copied to the target libraries can complete the data synchronization, is suitable for data analysis scenarios,Due to CDC information was stored in the table corresponding to the shadow in the table, unable to support based on the transaction (the main library the same transaction involving multiple tables) synchronization, so if there is a risk from the library for trading business, and when the source table structure change need to reset the CDC, increases the maintenance costs,
At present domestic Beedup specially used in the SQL Server database replication software, based on the transaction synchronization master database changes, through analyzing the main library journal of DDL and DML implementation database complete synchronization,
CodePudding user response:
Table level with FTP replication, level of library with the transaction log transmission, can satisfy this need.CodePudding user response:
Can consider to try Shareplex replication. It can be used to make the high availability of data backup copy,But the disadvantage is that do not support the DDL replication. Only support DML (Insert, delete and Update) operation.
https://www.quest.com/products/shareplex/shareplex-for-sql-server.aspx
CodePudding user response:
Can consider to try Shareplex replication. It can be used to make the high availability of data backup copy,But the disadvantage is that do not support the DDL replication. Only support DML (Insert, delete and Update) operation.
https://www.quest.com/products/shareplex/shareplex-for-sql-server.aspx
CodePudding user response:
Spirit bees database replication software Beedup support based on synchronous replication log parse SQL Server database, software based on real-time transaction unit duplicate data changes, support the DDL and DML synchronization, deployment, maintenance is simple,CodePudding user response:
In 2018, with Beijing spirit bee Beedup V4.0 landing requirements: the foreign capital enterprise project SQL Server two-way synchronous replication (ali cloud - local)The boss (German) didn't believe that China can also be the research tools, he only believe in oracle, IBM... (expensive)
CodePudding user response:
People's demand is not synchronous, just hope to compare the difference of architecture,General synchronization tools, network communication, when can be normal use?