Online Documentation for SQL Manager for SQL server

Export data as SQL Script


You can export data from a database table into SQL script with INSERT INTO statements in one of the following ways:

  1. Open the Data or Results tab, press the iconTools_ExportAsSQLScript Export Data as SQL Script on one of the Data View toolbars and set export parameters in the opened Export as SQL Script Wizard.
  2. Open the Data or Results tab, choose Data Manipulation | iconTools_ExportAsSQLScript Export Data as SQL Script in the Data Grid context menu and set export parameters in the opened Export as SQL Script Wizard.
  3. Open the table context menu in the DB Explorer, choose the Data Manipulation | iconTools_ExportAsSQLScript Export Data as SQL Script item and set export parameters in the opened Export as SQL Script Wizard.

 

Note: In order to extract table DDL (CREATE TABLE statement), check the CheckBox Add CREATE TABLE statement box at the Step 1.