Prerequisites
- AWS Aurora PostgreSQL cluster
- Access to AWS Console
- Xata account and project setup
- Network access to your Aurora cluster
Install and Configure the Xata CLI
Install the Xata CLI:Network Configuration
Option 1: Public Endpoint (Less Secure)
If your Aurora cluster has a public endpoint:- Whitelist Your IP:
- Go to your Aurora cluster → Security Groups
- Add a rule allowing PostgreSQL (port 5432) from your IP address
- Or temporarily allow from anywhere (0.0.0.0/0) for migration
Option 2: VPC Access (Recommended)
For better security, run the migration from within AWS:-
EC2 Instance in Same VPC:
- Launch an EC2 instance in the same VPC as your Aurora cluster
- Install Xata CLI on the EC2 instance
- Run the migration from there
-
GitHub Actions with AWS Credentials:
- Use GitHub Actions with AWS credentials
- Configure the action to run in your VPC
- Use the private endpoint for connection
Get Connection String
Initialize Xata Project
Set up your Xata project configuration:Configure the Migration
Set up your clone configuration with optional anonymization:Start the Migration
Begin the data transfer:Monitor Progress
Check the migration status:Verification
After migration, verify your data:-
Connect to Xata Branch:
-
Check Data Integrity:
- Test Relationships: Verify foreign key relationships work correctly
Next Steps
- Explore Xata branching for development workflows
- Learn about schema changes with zero downtime
- Set up continuous sync for ongoing replication
- Consider deployment options for your Xata instance