Migration Guides
Migrate your existing PostgreSQL databases to Xata using xata clone
Migrate your existing PostgreSQL databases to Xata's platform using xata clone. This tool efficiently copies data between PostgreSQL instances, supporting both one-time migrations and continuous replication.
What is xata clone?
xata clone is a powerful tool for copying data between PostgreSQL instances efficiently. You can use it to import your existing database (from RDS, Cloud SQL, Supabase, etc.) into Xata with optional data anonymization for staging & development environments.
Prerequisites
Before starting any migration:
- Source Database Access: You need the connection string (host, port, database name, user, password) of the source database
- User Privileges: The user should have sufficient privileges to read data
- Network Access: Ensure your environment can reach the source database
- Xata Project: Create a Xata account and project with a target branch
Cloud Providers
Migrate from major cloud PostgreSQL services:
- AWS RDS & Aurora - Amazon's managed PostgreSQL services
- GCP Cloud SQL - Google Cloud's managed PostgreSQL
- Google AlloyDB - Google's PostgreSQL-compatible database
- Azure Database - Microsoft's managed PostgreSQL service
Self-Hosted & Other Providers
Migrate from other PostgreSQL deployments:
- Self-Hosted PostgreSQL - Your own PostgreSQL instances
- Neon - Serverless PostgreSQL with branching
- Supabase - Open source Firebase alternative
- Heroku Postgres - Heroku's managed PostgreSQL
- DigitalOcean Managed Databases - DigitalOcean's PostgreSQL service
Other Databases
Migrate from non-PostgreSQL databases:
- MySQL - MySQL to PostgreSQL migration with schema conversion
Getting Help
Need assistance with your migration?
- Join our Discord community for real-time help
- Explore core concepts to understand Xata's features
- Check out tutorials for advanced workflows