Online Documentation for SQL Manager for MySQL

Export as SQL Script Wizard

Export as SQL Script Wizard allows you to export data from a table / view or from a query result to SQL script as a number of INSERT statements. You can save your settings as a template any time for future use.

To start the wizard, right-click the object in DB Explorer, select the Data Manipulation | Export Data as SQL Script...context menu item.

Alternatively, you can open the Data tab of Table Editor / View Editor or the Result(s) tab of SQL Editor / Query Builder, right-click the grid there, then select the Data Manipulation | Export <object_name> as SQL Script... context menu item.

• Selecting destination DBMS
• Setting destination file name
• Setting BLOB options
• Selecting fields to export
• Setting export options
• Editing result SQL script
• Exporting as SQL Script