Import & export

Move data in and out — from quick clipboard copies to file exports and full database packages.

Exporting to a file

The Export… action writes the result to a file as CSV, JSON or SQL (INSERT statements). It exports your current selection, or the whole result set when nothing is selected.

Copying to the clipboard

The grid's right-click Copy as menu offers more formats for pasting elsewhere: CSV, TSV (with or without headers), Markdown, HTML, and SQL INSERT.

Importing CSV

Right-click a table and choose Import CSV. Map the CSV columns to the table's columns in the dialog, and SQL Explorer inserts the rows with parameterised statements. CSV is the supported file import format.

SQL Server BACPAC / DACPAC

The bundled SQL Server BACPAC/DACPAC tool plugin exports and imports SQL Server databases as BACPAC (schema + data) or DACPAC (schema only), powered by DacFx in-process. A separate Universal Backup & Restore tool does datatype-correct backup and restore for any connected database. Both are tool plugins.