Exporting data to a script

Use the Data Transfer Wizard to write the selected database's objects and data to an SQL script — useful for backups, migrations, or keeping a schema under version control.

To export to an SQL script:

1. Choose Import/Export → Data Transfer Wizard from the main menu.
2. On the Action page, select Export data from the selected database.
3. On the Destination page, select SQL Script, choose the destination file name, and click Next.

4. Choose the file encoding, then click Next.

   

5. Choose additional options, then click Next. One of them, Continue on error, decides what a failure does to the rest of the run — see When a transfer hits an error.

   

6. Select the types of objects to export, then click Next.

   

7. Select the individual objects to export, then click Next.

   

8. Review your choices and click Next to start, or Back to adjust. You can Cancel during the transfer.

9. Click Finish to close the wizard.

See also: Importing data from a script · Exporting data to SQL