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 can work with the following kinds of databases:
- Folders with Paradox, dBase, FoxPro, text, or CSV files. In such folders, each data file represents a database table.
- ODBC data sources. Supported in Exportizer Pro and Exportizer Enterprise.
- Multi-table file databases like Microsoft Access, SQLite, Firebird, Interbase and some others. Supported in Exportizer Enterprise.
- Server databases of type Oracle, PostgreSQL, SQL Server, DB2, MySQL etc. Supported in Exportizer Enterprise.
- All Exportizer editions can open Microsoft Excel files as multi-table 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 Multi-Table File Databases
Exportizer Enterprise allows to create file databases of the following types:
- SQLite
- Firebird
- Interbase
- Microsoft Access (.mdb)
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 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 for that.
Creating Database Tables
You can consider all the ways to сreate database tables in Exportizer.
See also