SQLGate - The Most Intelligent IDE for Database
  • English
Edit

Wizard

Create table Wizard

Supports : support-database

This is how to create tables without writing CREATE statements.

  1. Connect to database.
  2. On the main menu bar, go to Create>Table. Or simply right-click on tables on Object Panel, and select [New Table].

create table wizard menu

  1. On a given blank table creator sheet, enter name of the table. If needed, add comment. Press Enter to move to the next field.
  2. Customize the tables by setting constraints, storage, and options.

create table wizard column form

  1. After you add all the fields, click [View SQL] to see SQL statement that is automatically generated.
  2. Once you are done, click [OK].
  3. On the SQL window, check if your query has been carried out correctly.
  4. After checking, click [OK].
  5. On Object Panel, click [Refresh] to see the new table added on the list.

Export data with Data Export Wizard

Supports : support-database

You can export tables, views, or query results in different document types.

Supported document types

Document typeextension
DBasefile*.dbf
text file.txt,.csv
Excel file*.xlsx, *.xls
SQL script file*.sql
MS Access file*.mdb

Export data

Export data on SQL Editor

  1. Connect to database.
  2. On the main menu bar, selelct File>New>SQL Editor. Or, simply click [SQL Editor] on the Toolbar or press Ctrl+N.
  3. Write SQL.
  4. Click [Run] or press F5.
  5. Right-click on the grid, and select Export Data>Excel file.

export data in query result

  1. As Data Export Wizard window opens, select a file type and then click [Next].
  2. On Set File path and Additional option, select a file to export. If necessary, set the number of records for each file and click [Execute].
  3. Check the file(s).

Tip : Let's say the file name of the exported data is dept.xlsx. If Record count is larger than the input value, files will be created as: dept_001.xlsx, dept_002.xlsx.

Export data from Object Panel/Search for Object.

  1. Select a table from Object Panel or Search for Object.
  2. Right-click on the table, and select [Export Data].

export data in order panel

  1. As Data Export Wizard window opens, select a file type and then click [Next].
  2. On Set File path and Additional option, select a file to export. If you check Records Count of Each file, additional files will be created if the number goes beyond the number you entered. Then click [Execute].
  3. Check the file(s).

Note: Let's say the file name of the exported data is dept.xlsx. If Record count is larger than the input value, files will be created as: dept_001.xlsx, dept_002.xlsx.

Export data from multiple tables at once

  1. On the main menu bar, go to Tools>Export Data.

export data in toolbar

  1. Select tables to export. You can select multiple tables.

  2. If you choose one table

    It will function exactly the same as you export data from Object Panel/Search for Object.

  3. If you choose more than one table,

    On [Export Folder], click the browsing icon to select a folder to export the data to.

  4. Click [Start]

  5. You can see the files on [Export Folder] by the names of the tables.

choose object window to export data

Note: The created files are named after the tables.

Import Data with Data Import Wizard

Supports : support-database

You can import different types of documents. This section explains how to import Excel files and text files.

Supported File Types

Document typeextension
DBasefile*.dbf
text file.txt,.csv
Excel file*.xlsx, *.xls
MS Access file*.mdb

Importing data from Excel file on Object Panel/Search for Object

  1. Select a table from the Object Panel or Search for Object.
  2. Right-click and select [Import Data].
  3. When Data Import Wizard opens, check [Excel File] and click [Next].
  4. On Select File to Import, click the icon to browse and select the file to import. Click [Next].
  5. On Additional Options Settings, customize options for the importing data and then click [Next].
  6. The first row: If the first row of the data consists of a field name, enter 2. If not, enter 1.

import data wizard file additional option

  1. The last row: If you don't input any value, all rows from the file will be read.
  2. On File Preview section, you can map the columns from the file and table. Click [Auto Columns Mapping] to map columns in the file to the fields on the table. Click [Next].
  3. On Column Mapping window, check if the source file and the destination file are mapped correctly.

import data wizard column mapping

Note: >>>>If you don't select keys on Column Mapping window, the data is simply added or copied. If you want to activate other importing mode, select the keys on Column Mapping window.

  1. On Data Preview window, check the data you are about to import. To proceed, click [Next].
  2. On Run Summary window, select one from Import Mode and click [Execute].

import data wizard run summary

  • Append: Add Records to the destination table.
  • Update: Update Destination Record that matches with Record in Source.
  • Append/Update: If Destination Record exists, update it. Otherwise, add it.
  • Delete: Delete the destination Records that match records in source.
  • Copy: Delete all destination records, and replace with source contents.
  • Append New: Add Records only if there is no destination record.
  1. Check if the data has been imported successfully and then click [OK].

Importing text or .CSV files from Object Panel/Search for Object.

  1. On the Object Panel or Search for Object, select a table.
  2. Right-click on the table and select [Import Data].
  3. When the Data Import Wizard window opens, check [Text File] and then click [Next].
  4. On Select File to Import, browse a file to import and click [Next].
  5. On File Option Settings, customize options for the importing data and then click [Next]. You must select one from the Field Separator to proceed.

import data wizard fiile option

  • Field Separator: It is a symbol that marks a line break in a text file. Check if there is a specific symbol such as tab, comma, or other symbols.
  • Fixed width: Check if the width of the characters from each field is fixed.
  • Field Separator: Check [Field Separator] from above, and then select a field separator from the given symbols. You can add your own symbol on the field given next to Miscellaneous Symbol.
  • Line break: Select one line terminator from CRLF, CR, and LF.
  • Qualifier: From None, double quotation, and single quotation, select one qualifier that separates characters.
  1. On File Preview window, you can map rows from the file and the tables. Click [Auto Column Mapping] to consecutively fetch the data and then click [Next].
  2. On Column Mapping window, check if the source file and destination file are mapped correctly.

import data wizard column mapping

Note: If you do not check the keys on Column Mapping window, you can only add and copy the data. To activate other importing mode, select the keys.

  1. On Data Preview, check the data you are about to import. To proceed, click [Next].
  2. On Run Summary window, select one from Import Mode and click [Execute].

import data wizard run summary

  • Append: Add Records to the destination table.
  • Update: Update Destination Record that matches with Record in Source.
  • Append/Update: If Destination Record exists, update it. Otherwise, add it.
  • Delete: Delete the destination Records that match records in source.
  • Copy: Delete all destination records, and replace with source contents.
  • Append New: Add Records only if there is no destination record.
  1. Check if the data has been imported successfully and then click [OK].
← Edit data without writing SQL statementsManage Connections →