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.
Exportizer work with the following kinds of databases:
- Folders with Paradox, dBase, FoxPro, text, or CSV files. In such folder, each data file represents a database table.
- ODBC data sources. Supported in Exportizer Pro and Exportizer Enterprise.
- Multi-table file databases like Microsoft Access, Microsoft Excel, 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.
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:
- 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 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.
- If you export the source dataset to dBase format, the result will be a dBase file/table in a target folder.
- If you export the source dataset to CSV format, the result will be a CSV file/table in a target folder.
- If you export the source dataset to a SQLite database, the result will be a SQLite table in that database.