Exporting data to another SQLite database

Use the Data Transfer Wizard to copy tables and views from the selected database into another registered SQLite database.

To export to another SQLite database:

1. Choose Import/Export → Data Transfer Wizard from the main menu.
2. On the Action page, select Export data from the selected database.
3. On the Destination page, select Another SQLite database, choose its alias, and click Next.

4. Choose additional options, then click Next. One of them, Continue on error, decides what a failure does to the rest of the run — see When a transfer hits an error.

   

5. Select the types of objects to export, then click Next.

   

6. Select the individual objects to export, then click Next.

   

7. Review your choices and click Next to start, or Back to adjust. You can Cancel during the transfer.

8. Click Finish to close the wizard.

See also: Importing data from another SQLite database · Copying tables between databases using the clipboard