EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

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 iconTools_ExportAsSQLScript 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 SQL Editor / Query Builder, right-click the grid there, then select the Data Manipulation context menu group and proceed to the iconTools_ExportAsSQLScript Export <object_name> as SQL Script... item within this group, or use the iconTools_ExportAsSQLScript Export as SQL Script item of the Navigation bar.

 

menuExportAsSQLScript

 

 

 

 

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.

 

 


See also:

Export Data Wizard

Import Data Wizard

Bulk Insert Wizard

Using templates