Online Documentation for SQL Manager for SQL server
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 context menu group and proceed to the 
Export Data as SQL Script... item within this group.
Alternatively, you can open the Data tab of Table Editor / View Editor or the Result(s) tab of Query Data / Design Query, right-click the grid there, then select the Data Manipulation context menu group and proceed to the Export <object_name> as SQL Script... item within this group, or use the Export as SQL Script item of the Navigation bar.
- Selecting destination DBMS
- Setting destination file name
- Setting BLOB options
- Selecting column to export
- Editing the result table definition
- Setting export options
- Exporting as SQL Script
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
No |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
