Migrate
Learn how to migrate data from other systems to Piglet Run.
Overview
Piglet Run supports migration from:
- Other PostgreSQL: Migrate from existing PostgreSQL instances
- MySQL/MariaDB: Convert and migrate from MySQL
- Cloud Databases: AWS RDS, Google Cloud SQL, Azure Database
- Files: Import from SQL dumps or CSV files
Quick Migration
Migrate from another PostgreSQL:
Migrate from PostgreSQL
Direct Connection
From pg_dump File
Schema Only
Migrate from MySQL
Direct Migration
With Type Mapping
Migrate from Cloud
AWS RDS
Google Cloud SQL
Import Files
SQL Dump
CSV Files
Multiple CSV Files
Migration Options
| Option | Description |
|---|---|
--schema-only |
Migrate structure only |
--data-only |
Migrate data only |
--no-owner |
Skip ownership |
--parallel N |
Parallel jobs |
--exclude TABLE |
Exclude tables |
Verification
Verify migration:
Next Steps
- Learn about Backup
- Understand PostgreSQL Configuration