Using the Import Tool
PhoenixDB's built-in import tool lets you migrate data directly from another PostgreSQL database.
One-Click Import
No need for command-line tools. Just provide your source database connection string, and we'll handle the migration for you.
How It Works
Open Import Modal
In your dashboard, click on a database and select "Import Data" or use the import button.
Enter Source Connection String
Provide the full connection string of your source database:
postgresql://user:password@source-host:5432/source_db?sslmode=requireStart Import
Click "Start Import" and we'll begin transferring your data. The process runs in the background.
Monitor Progress
Track the import progress in real-time. You'll see which tables are being imported and the overall status.
Import Status
The import tool shows real-time status updates:
Import is in progress
All data has been imported successfully
Import encountered an error (check logs for details)
What Gets Imported
Included
- • Tables and data
- • Indexes
- • Constraints (PK, FK, unique)
- • Sequences
- • Views
- • Functions
May Require Manual Setup
- • Extensions (need to be enabled first)
- • Custom roles/permissions
- • Replication slots
- • Subscriptions
Tips for Successful Import
Ensure Source is Accessible
Make sure your source database allows connections from PhoenixDB servers. You may need to add our IP ranges to your source database's allowlist.
Plan for Downtime
For large databases, consider scheduling the import during low-traffic periods. Any data written to the source after the import starts won't be included.
Verify After Import
After the import completes, verify your data by running a few test queries. Check row counts and sample data to ensure everything transferred correctly.