Database Migration & Export

Database Migration & Export

Safely move the local SQLite history to Azure PostgreSQL, or export a portable copy of the current database.

Back to deployment
Active databaseSQLite
SQLite sourceReachable
PostgreSQL targetNot configured
Migration verificationNot verified

Export current data

Exports use the database currently running the platform. They do not change or lock the selected backend.

CSV archiveOne CSV per table plus a manifest with row counts and SLA-critical totals.
Export CSV ZIP
JSON archiveOne JSON Lines file per table plus the same verification manifest.
Export JSON ZIP
Raw SQLite snapshotA consistent SQLite backup copy. Available only while SQLite is the active database.
Export .db
Export contents

Exports include services, probe results, outages, maintenance, incidents, certificates, backup health, monitor locations/states, audit history, settings and the other application tables. Secrets held only in environment variables or Key Vault are not exported.

SQLite → Azure PostgreSQL

This utility copies the configured SQLite database into the configured PostgreSQL database and verifies the result before marking it ready for cutover.

Configure AZURE_POSTGRESQL_URL before attempting migration.
What happens

1. Both databases are connectivity-tested.
2. PostgreSQL schema is created if required.
3. A non-empty target is blocked unless replacement is explicitly confirmed.
4. Tables are copied in dependency order inside a target transaction.
5. PostgreSQL sequences are reset.
6. Every table row count and SLA-critical summary is compared.
7. Only a fully matching result is marked Verified.

Migration verification

No migration has been run yet.