Migrate

Learn how to migrate data from other systems to Piglet Run.

Overview

Piglet Run supports migration from:

Migrate from another PostgreSQL:

pig migrate postgres://user:pass@source-host/dbname

pig migrate pg \
  --host source.example.com \
  --port 5432 \
  --user migrate_user \
  --database production

pig migrate import backup.sql

pig migrate pg --host source.example.com --schema-only

pig migrate mysql \
  --host mysql.example.com \
  --user migrate_user \
  --database myapp

pig migrate mysql --host source --type-map mysql-to-pg.yml

pig migrate rds \
  --instance mydb-instance \
  --region us-west-2 \
  --profile aws-profile

pig migrate cloudsql \
  --instance myproject:region:instance \
  --credentials /path/to/credentials.json

pig migrate import dump.sql --database mydb

pig migrate csv data.csv --table users --database mydb

pig migrate csv ./data/ --database mydb

Verify migration:

pig migrate verify --source postgres://source/db --target postgres://target/db