Want to synchronize two database servers, and synchronize the primary database data to the database, within budget, 5000,
Tried SyncNavigator, the software will be inserted into a database table field, will destroy the table structure, so does not meet our requirements,
Subscribe to also can not release, the need to restart the database,

CodePudding user response:

Microsoft is the most, the most convenient technology is Alwayson, require version: 2012 +, suggest that at least 2014. 2017201 is better,
If you don't want to do, even restart the database may not be able to complete, didn't also the necessary, restart it can have a much impact on the business in the morning at night?

In addition to Microsoft's own tools, with other third-party software, nothing of particular,
Is bound to add additional database objects, such as trigger,

The need to have complete control, then you can write their own procedures to sync, but this time cost also is higher, also need to have very strong programming ability to,

CodePudding user response:

Ali datax can give it a try

CodePudding user response:

Subscribe to also can not release, the need to restart the database
-- -- -- -- -- -- -- -- -- -- - configure this not restart, can add and remove at any time

CodePudding user response:

Official own things is the most of, also don't need the extra cost

CodePudding user response:

Use Microsoft's own components, can try AlwaysOn