In most cases, data exporting software works with existing databases, i.e. copies data from one database to another, exports data from database to external file(s) or clipboard. But some tasks require creating a new destination databases before exporting. Here, Exportizer opportunities to create databases are described.

Please do not confuse databases with database tables; read notes about creating database tables below.

Database kinds

Exportizer work with the following kinds of databases:

Creating Paradox, dBase/FoxPro or text/CSV databases

These databases are folders with the corresponding database files. You can create a folder using Exportizer file saving and opening dialogs or by Windows Explorer or any other appropriate tool.

After creating the folder, you can open it as a database in Exportizer.

Note: You can create folders automatically when exporting data by command line or action files using /CreateTargetContainer switch.

Creating file databases

Exportizer Enterprise allows to create file databases of the following types:

To create a database, click Connect / Open Data Source button  or choose File | Register New Database... menu. Select FD interface. Choose the database type for the new database (SQLite, Firebird, Interbase, or Microsoft Access). Below, click Create a blank file database button  and choose a file name for it.

After the database is created, you can open it there in just a few clicks.

Note: You can create these databases automatically when exporting data by command line or action files using /CreateTargetContainer switch.

Creating server databases like Oracle, SQL Server, PostgreSQL etc

Exportizer Enterprise allows to open databases of these types and export data from them or to them, but does not support creating new databases. Use specialized tools to create such databases.

Creating databases tables

In Exportizer, you can create database tables in target database by exporting data to that database.

For example: