What does Data Compare synchronization wizard "Use Transactions" option mean? Is this related to transaction logs?
Use Transactions option is used to determine how data is committed when sync script is executed. This option does not have any effect on the transaction log file of the database. Here are the different settings for this option:
Specify the method to use for committing transactions:
-Commit the entire generated SQL script
-Commit each table in a transaction
-Commit each operation in a transaction
-Commit every N statements in a transaction
If an error occurs during script execution, the transaction is rolled back depending on the option selected.
