Export Changes as T-SQL

 

This export option automatically creates T-SQL scripts that update and delete the records as required in a relational database system such as SQL Server, Access, MySQL or Oracle.  It is strongly recommended that you first run such scripts on a test copy of your database to ensure the correct data is being updated and deleted – and that you have reliable backup and restore procedures to restore your data if needed.

You first need to specify the name of the table in your source data that you want the scripts to update:

Then press the ‘Export Changes as T-SQL’ button.  The results look like this:

 

 

Related Topics

Export Changes Made