Is there any way to convert differential backup to SQL statements which will produce identical results when applied?
Or any other solution similar to binary log in MySQL?
A:
please see the below links :
http://weblogs.sqlteam.com/tarad/archive/2007/02/26/60120.aspx
masoud ramezani
2010-03-08 10:32:59
+1
A:
No.
SQL Server differential backups contain those pages that have been changed since the last full backup.
This will be completely unrelated to SQL DML statements that have been run and the data can not be extracted.
What are you trying to do though?
gbn
2010-03-11 22:31:00
I was trying to import data to MySQL and then do periodical synchronization the same direction. Looks DTS is way to go?
noonex
2010-03-12 12:04:13
Yes, DTS or SSIS from DB to DB
gbn
2010-03-12 13:51:01