Export and Import

You can use a variety of methods to export data and object structures from a database. In addition, you can export data in SQL, CSV, XLS, XLSX formats. In Chat2DB, you can export object structures and data separately. This means that you can export the structure of a table or view and then export data from those objects.

Here (opens in a new tab) to see the progress of the export.

Export Object Structure

Tip: It is recommended not to change the data during the export process to prevent any potential data integrity issues.

Export the entire database

1. Select the database for which you want to export the object structure and click Export structure only.

2. After selecting the save path, click Open file to view the exported file after the export is completed.

3. Export successful!

Export a single table

The method is the same as above, just select single table to operate.

Export object structure and data

Tip: It is recommended not to change the data during the export process to prevent any potential data integrity issues.

Export the entire database

1. Select the database whose object structure you want to export and click Export structure and data.

2. After selecting the save path, click Open file to view the exported file after the export is completed.

3. Export successful!

Export a single table

There are three methods: The first method is the same as above, select single table to operate.

Second method: Select Export data, and select the file format and save location you want to export.

Third method: Click Export on the right side of the editor bar to export data:

• Export result set csv: Export the entire query result set as a CSV file

• Export result set insert sql: Export the database query results as a series of SQL INSERT statements

• Export result of current page set csv: Export the results on the current page as a CSV format file

• Export result of current page set insert sql: Export the results displayed on the current page as an INSERT SQL statement

Import object structure and data

Import the entire database

Randomly select a database, right-click and select Run SQL file to import!

Import a single table

1. Select the table whose object structure you want to import and click import data.

2. Select the format and save path of the file to be imported.

3. Import successful!