Data Export in 602SQL

Data Transfers

Data import in 602SQL

Data import is a data transfer from a file into a 602SQL table. 602SQL accepts files in these formats:

• Internal format 602SQL (used mainly for backup purposes and for data transfer between different 602SQL installations)
• Text formats
• DBF format

Text formats can have two forms:

• The values of individual columns are in columns and the records are in rows. The first row specifies names of the columns the contents will be inserted to.
• The CSV generalized format (Comma Separated Values). Values are separated by a separator.

Data imported from a DBF file that contains a field of variable-length can be used (if the field is only a memo field in the FoxPro 2 or dBase IV formats). This memo field will be stored in a TEXT type column.

Data transfers are created in the data transfer designer interface. If the data is imported into an existing table, select this table on the control panel and execute the Import Data action. A wizard for transfer design with predefined values of the target object (602SQL table) will appear. Fill in the source file (type and name) and, if needed, adjust the transfer description, which is generated automatically. The designed import can be saved for later use.

Application import as a whole is much faster than data import on each table.

Data Export in 602SQL

Data Transfers