Step 7 - Specifying import mode

This step of the wizard allows you to define the records processing mode as Insert All, Insert New, Update, Update or Insert, Delete, Delete or Insert mode.

Import Mode

• Insert all: all records from the source file are inserted into the tables irrespective of whether any records exist in the destination table or not
• Insert new: already existing records are skipped, and new records are inserted into the destination table
• Update: all existing records are updated from the source file
• Update or insert: already existing records are updated and new records are inserted into the destination table
• Delete: already existing records are deleted
• Delete or insert: existing records are deleted and new records are inserted into the destination table

Here is an example of some import modes offered by Data Import utility:

All import modes (except for the Insert All mode) are based on primary key values information. In order to perform import operations with these modes used you need to have matches between the source file primary key column(s) and the destination table primary key column(s).

It is applied to all other import modes, except for the Insert all mode. For all these modes (except for the Insert all mode) it is obligatory to select the primary key fields. This field (or fields) is used as key field to identify specific data in the target database.

The key columns for these operations are defined at the Selecting key columns step of the wizard.

If the Update value is selected for Import Mode, then you need to specify the Primary Key field(s) that will serve for data identification of your source file with the data of the target table. The source file must contain the column(s) that will correspond to the Primary Key field of the target table. If the target table contains a record in which the value of the primary key field coincides with the value of the corresponding column of the source table, the data stored in this table record will be updated. You can specify the field(s) which will be used for identification at Step 7 of the wizard. This field(s) will only serve for identification and will not be imported.

Native mode kind

The Native mode uses the Single Commands method that serves to generate and execute single SQL commands on the server, whereas the Bulk Insert mode uses native commands for a particular server: BULK INSERT for Microsoft® SQL Server™.

Keep Nulls

This option specifies that NULL columns should retain a null value during the bulk copy operation, rather than have any default values for the columns being inserted.

Fire Triggers

This option specifies that any insert triggers defined on the destination table will execute during the bulk copy operation.

Bulk Insert File Name

Type in or use the button to specify the name and path to the bulk insert file name using the Save As... dialog. If data_file is a remotely stored file, specify the Universal Naming Convention (UNC) name.

Bulk Insert Field Terminator

Specify the field terminator to be used for char and varchar data files.

Skip this step

Check this option to skip the current step in the future. To edit the list of skipped steps, use the Skipped Steps group available in the General section of the Preferences dialog.

When you are done, press the Next button to proceed to the next step.