Click in the Image (to Zoom) OR

on the "Check Mappings" Button to open a screenshot OR

on any Column Name in the Destination (right) side to open a Step by Step tutor page

(hover your mouse on the Buttons to display the Task TIP)

Blobs

When the Table has Blob Data type Column(s) these will be stored in (internal) Temp Tables. Depending on thresholds defined in your settings this can be done either in Memory (faster) or in HD (slower)

In this example they are used in Memory Tables as displayed on screen (check docs for more detailed explanations)

Listbox Icons & Colors

To display a Legend Infos screen click on the relevant button

Data (Tab)

To display the First 50 records already read, click on this Tab

Table Structures (Tab)

To display the Table Structures (helpful to understand duplicates from the Unique Keys), click on this Tab

Step 1 : Link Columns

Use the Radios to select the type of linking method to use then click on the "Link Columns" Button OR use Drag & Drop from Source Column to Destination

Clear link & mappings : select the Column in Destination side and right-click (option to clear all functions - conditions etc...)

Step 2 (optional) : Chek your mappings

If you wish to see what your data will be AFTER applying the mapping options click on Button "Check Mappings" and you will have access to a new Tab where you will be able to scan on the first 50 records with all MAPPINGS applied (you can do it here to open a popup window with a screenshot)

Open Column Mapping Screen

If you wish to define a column Mapping you double-click on the column Name to work on in the Destination Right Panel (click there to start the Tutor)

Step 3 (optional) : Save as Profile

You can save all these settings (source and destination) in a Profile to use again at a later time (use Button "Save as Profile")

(this allows you for example to test different mappings combinations)

Step 4: Transfer Data

When you are satisfied all is defined as you need, launch the Data Transfer process (Button "Transfer Data") - you will be able to repeat this as many times as you wish "playing" with Ranges and mapping options

Options you can define before Transferring

Number of Records and Record Ranges

You can define the Number of Records to Transfer or the Low and High Range to transfer

(this allows you for example to transfer only from record #125 to record #255)

Source SORTING order

You can define the Source SORTING Order : Drag & Drop from Source Column to relevant entry field, add a leading - if you need a descending order on the added column (default is ascending and you do not need to add a leading +)

(this allows you for example to sort the source table in any special way you may require during Updates)