Consult master data synchronization issues

独行风中

For two machines, you need to back up the data of one machine to the other machine. Because the amount of data is too large, I want to take an incremental backup method. I don't know if there is a good way to solve it? thank you all!
(I've tested snapshot publishing and it seems that incremental operations are not possible.)

vipmafia

All you have to do is backup the data sheet?
How about using packets?
Then establish a job or task plan and execute it on time every day.

116657396

Do a snapshot copy first, then transactional copy.

德鲁伊

Snapshot publishing cannot of course be incremental

The transaction publishing method is incremental

You can first back up and then start transactional replication, and select the "existing architecture" mode

德鲁伊

Of course, this is done faster, but you need to stop your database service

If you don’t want to interrupt the data service, you can directly copy the transaction. Transaction replication is to perform snapshot copy first, and then incremental copy in real time.

And choose to re-apply the architectural pattern

独行风中

Just saw it, thank you for your answers, let me test it first!

独行风中

I ran into a problem while testing today.
I first copied the database to another computer, and then used things to publish, and the other party forced a subscription, but an error was reported. I added two records to the table. When the synchronization was started, it prompted that the stored procedure could not be found. This stored procedure, let's see what's going on, thank you!!

Error message: (CALL sp_MSins_ll_a1 (23714, '1111100001', 2015-11-24 11:47:39.577, 2015-11-22 16:12:20.000, '172.17.175.114', '00:40:46:51: 63:8d', '202.108.36.145','wmllqd.yeah.net/', 1,'', -100001, 0x65717774717774717774)}

Last command: The stored procedure'sp_MSins_ll_a1' could not be found.

Error details: The stored procedure'sp_MSins_ll_a1' could not be found.
(Source: LVKY (data source); Error code: 2812)

独行风中

I already know this problem.In fact, when creating a release, you don't choose to create a stored procedure. If you want to choose, you must write the stored procedure yourself.I just lost my head and thought the stored procedure was created automatically.
    However, I have encountered a new problem. I will first see if I can solve it. If you have any knowledge, please let me know.
Error message: insert into "ll_a1" values ​​(23720, '1111100001', 2015-11-24 11:47:39.577, 2015-11-22 16:12:20.000, '172.17.175.114', '00:40:46 :51:63:8d', '202.108.36.145','wmllqd.yeah.net/', 1,'', -100001, 0x65717774717774717774)

The previous command: Only when the list of columns is used and IDENTITY_INSERT is ON, can you specify an explicit value for the identity column in the table'll_a1'.

Error details: Only when the list of columns is used and IDENTITY_INSERT is ON, can you specify an explicit value for the identity column in the table'net_http'.
(Source: LVKY (data source); Error code: 8101)

德鲁伊

I already know this problem.In fact, it is enough to not choose to create a stored procedure when creating a release.If you want to choose, you must write the stored procedure yourself.I just lost my head and thought the stored procedure was created automatically.

======================
This stored procedure can be generated by the system, but it must have the role of Sysadministrators to connect to the subscriber. Then, the owner of the created stored procedure is dbo, so there is no problem - I have tested this problem

德鲁伊

Error message: insert into "ll_a1" values ​​(23720, '1111100001', 2015-11-24 11:47:39.577, 2015-11-22 16:12:20.000, '172.17.175.114', '00:40:46 :51:63:8d', '202.108.36.145','wmllqd.yeah.net/', 1,'', -100001, 0x65717774717774717774)

The previous command: Only when the list of columns is used and IDENTITY_INSERT is ON, can you specify an explicit value for the identity column in the table'll_a1'.

Error details: Only when the list of columns is used and IDENTITY_INSERT is ON, can you specify an explicit value for the identity column in the table'net_http'.
(Source: LVKY (data source); Error code: 8101)

==== This is because your table "ll_a1" contains an Identity field, and you should use "For Copy"=ON in this field.