Some time ago, due to the need, the data in database A needs to be migrated to database B to make the data in both databases the same. I used SSIS to complete it, because it was a new table created by myself at that time, so when creating the table, I added the rowversion field to distinguish which data differences between A and B databases, and only migrated data with different version numbers, without copying the entire table to improve efficiency. However, it is not always necessary to operate on a new table, for example, when we need to operate an existing table, there is no rowversion field in this table to distinguish between the old and new data, what should we do then?
In fact, before contacting the SQL Server database, I used the Mysql database, which would have a binlog to record what data was manipulated, but the sqlserver did not have a binlog, it had a transaction log file baiTransaction Log File is a file used to record database updates, with the extension ldf. You can compress the logs and use a third-party tool to view the logs. For example, log explore to view SQL log files.
For a detailed look at the Thing Log, check out this blog https://www.cnblogs.com/CareySon/archive/2012/02/14/2351149.html
|
Posted on 7/13/2020 2:16:20 PM
|
|
|
