Backing up and restoring a database

Open Backup & Restore from the connection menu. A backup exports the whole database — tables, columns, rows, keys and indexes, plus functions, triggers, enums and views where they can be captured — into a single SQL file.

Native tools when you have them

If your engine’s own dump tool is installed and on your path, AddisDB uses it, because that output is the highest-fidelity backup available and preserves details a generic export would miss. The dialog tells you which one it found. If the tool is missing — or it errors — AddisDB falls back to its own exporter and says so, rather than failing.

Restoring

Switch to the Restore tab and choose a dump file. Restores write to the database, so they follow the same rules as any other write: a read-only or production connection stays protected until you deliberately grant edit access.