Learn how to clone databases and environments in Piglet Run.
Overview
Cloning allows you to create exact copies of:
- Database: Clone a database for testing or development
- Environment: Clone the entire Piglet Run instance
- Schema Only: Clone structure without data
Quick Clone
Clone a database instantly:
pig clone db mydb mydb_copy
Clone Database
Full Clone
pig clone db production development
Schema Only
pig clone db production development --schema-only
Clone with Data Filter
pig clone db production development --filter "created_at > '2024-01-01'"
Clone Environment
Create Environment Clone
pig clone env --name staging
Clone to Remote Server
pig clone env --target user@remote-server
Clone from Snapshot
pig clone snapshot snap-20240115 --name dev-clone
Clone Options
| Option | Description |
|---|---|
--schema-only | Clone structure without data |
--no-owner | Skip ownership information |
--no-privileges | Skip privilege information |
--parallel N | Use N parallel jobs |
Use Cases
- Development: Clone production for local development
- Testing: Create isolated test environments
- Analytics: Clone for reporting without impacting production