Import and export

Use DbGate import & export system for flexible processing your data.

One-click export any data

Table or view - export whole table, view or MongoDB colllection from context menu

Query result - export result of any query or query designer

Table row subset - open table, apply some filters and export filtered data

Backup and restore SQL dumps

Supported databases - backup and restore now works for MySQL, PostgreSQL and MariaDB

Fast and robust - these operations uses native battle-tested backup/restore tools shipped with databases

Native tools shipped with Team Premium app . For Premium app, you need these native tools to be installed separately

Powerful import/export tool

Multiple source and targets - export or import multiple tales in one step

Combine anything - besides from DB import and export, you could also copy data between databases or transform one supported file format to another

Save job - the job could be saved for later or exported to NodeJS script, which could be run from command line

Data archive - is a special internal DbGate storage for intermediate data, data backups or data templates (stored on disk, uses NDJSON format)

Lot of supported formats

• CSV
• Excel
• JSON lines (NDJSON)
• JSON
• XML
• DBF
• Import/export formats are extensible with plugins