Database Tables

After opening (connecting) the database, all tables from it are shown in the left part of the main window. You can open needed table from the table list by clicking it or selecting it by keyboard means.

If you need to export more than one table at a time, click Select Tables button above the table list, and then select needed tables holding Shift or Ctrl down. Exporting multiple tables is available only on Exportizer Enterprise.

In the context menu of the Exportizer Enterprise table list, there is an option to open the table in Live Data Window mode, which allows to scroll down and export huge database tables without memory overflow. But this mode increases the database workload and slows down performance. It is recommended to use this option only when you cannot export a huge table due to memory errors. This option works for FD connections only. You can use it only for tables with primary key and cannot use for custom SQL queries.

Database Queries

Besides the tables, there is another type of datasets: SQL query result. Due to its flexibility and optimized database workload, it is the recommended dataset type to use. Working with SQL queries is available only in Exportizer Pro and Exportizer Enterprise.

To open a new SQL window, click New SQL Window button .