Scripting Options are listed on the second tab of the IDERA Data Compare Options window. Those options affect the way the synchronization script is generated but do not affect the comparison operation.
- Transaction size. Determines the size of the script that will be wrapped in a single transaction. Depending on the size of the databases/tables being compared the synchronization script may get to be extremely large. Wrapping such large scripts in a single transaction may not be possible due to transaction size limitations, and may not be acceptable for performance and other reasons. So, it is necessary to split the script into smaller "chunks" and wrap each of those "chunks" in individual transactions.
If the synchronization process is canceled or fails due to errors, only the current open transaction is rolled back. Changes committed prior to that transaction are permanent and cannot be reversed. To have an unlimited transaction size specify 0 as the max value. Having an unlimited transaction size ensures that all changes in the database are rolled back if an error occurs, but might be rejected by Oracle.
Finding the right transaction size depends on many factors - please adjust this option carefully to suit your specific environment.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal