Home
SQL Select online help Prev Page Prev Page
Introduction
About SQL Select
Version history
Supported database engines
Contact us
Using SQL Select
Connecting to a database server
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
The SQL workspace
SQL editor
Query selection
Data sets
Locking data sets
Exporting data sets
Export to text file
Export to Excel
Export to SQLite

Export to SQLite

Click on the Export data sets to Excel button (transfer_data) on the data sets toolbar. This will start the export process.

Select the data sets you want to export. Each data set will be exported to a different table. Thus, you need to give each table a unique name. You can export both the active and locked data sets. You can view the data contained in each data set by selecting the data set in the Available data sets
list.

export_sqlite_01  
 
Enter the database file name to export the data sets to. You can enter the name of an existing SQLite database, or the name of a new database. You also have the option of deleting any existing database of the same name, and also existing tables of the same name that you want to export the data sets into.

There are two SQLite options that help in speeding up the export process, at the cost of data integrity. The Exclusive access
option allows the SQLite engine to hold exclusive locks on the databases for the duration of the export process. The Synchronous off option allows the SQLite engine to continue processing once it passes data to the operating system, but it does not check if the data has been safely written to disk.
 
export_sqlite_02  
 
SQL Select will export the data sets to the SQLite database you named, and report its progress. Once the export process has completed, you can open the database by clicking on the Open database button. If you do not have any applications registered to open SQLite databases, SQL Select will open the folder containing the database file instead.
 
export_sqlite_03