Import and Export Data

Import/Export Data

Importing data with OLEDB/ODBC

The DQL command “open_oledb” can open OLEDB or ODBC drivers. The command accepts 2 parameters: connections string and SELECT statement. The output rows from external database can be inserted to table using DQL “bulk_insert” command. For more details go to FreeText sample.

Importing/Exporting CSV file

CSV import/export functionality has been built into ScimoreDB Manager. Just right click on the table and choose import/export sub-menu.

Type column delimiter character, choose CSV file input/output. If the first row in CSV contains column names, click on checkbox to ignore the first row for import or generate columns header for export.

Import SQL batch

Execute a list of INSERT SQL commands separated by ‘;’:

INSERT INTO TEST VALUES(0,0);
INSERT INTO TEST VALUES (1,1);
...

Backup/Restore database

ScimoreDB supports native hot-backup/restore functionality. Both commands are transactional, i.e. if RESTORE fails, the database will be restored to the previous state.

Related