602SQL Documentation Index  

Data Transfer Designer

The data transfer designer will open, if you:

How to Design a Transfer

The transfer designer is composed of two parts: a wizard that allows you to interactively choose and specify the data transfer parameters and the designer window that displays the transfer information summary and the grid describing the transferred columns.

Wizard Page 1

You must select the basic transfer type. A transfer between the database and a XML file or a transfer between the database and a data file. Only data transfers will be described here, XML transfers are described here. On this page you will get knowledge about creating XML transfer (and other objects) based on XSD scheme or XSL-FO form.

Wizard Page 2

You must specify the data source for the transfer here. You must choose data from the 602SQL database, ODBC data source or data in an external file. The control options in the bottom part will change according to this selection:

The last step on this page is (when transferring from a table or a view) the specification of a constraint condition for the transferred records (in the form of ID>100, where ID is the selected table column). If no condition is set, all records will be transferred.

Wizard Page 3

You must specify the data transfer target here. Again, you must choose whether you are importing to the 602SQL database (to an existing or new table), to an ODBC data source or an external file. The control options in the bottom will change according to this selection:

The last step on this page (when the target is a table) is the specification of the time when indexes should be rebuilt. The Incremental update during import choice means that the index is created for each imported record. The choice Rebuild index after import means that the import will be done first and then the index will be created. The second choice is faster for a large data set, but works only if duplicity will not occur when creating the index.

Wizard Page 4

You can specify some parameters for text transfers here:

When you finish the wizard, the actual transfer designer will open. The top part of the window contains summary information about the transfer from the wizard pages with the ability to go back and change the settings (buttons on the right). The contents of the transfer description in the grid depends on the transfer type (see Data transfers - transfer description). The grid contains the default transfer design that can be modified. If you modify the design, change the source or target structure, you may still generate the default design (use the Design / (Re)Create default design command).

You can check syntax by executing the Design / Validate command and start the transfer using the Transfer data command. Transfer progress can be monitored on the status line.