Transfer RDS Databases to New Accounts
Move RDS database instances from current account to new prod/nonprod accounts.
- Inventory all RDS instances and their dependencies
- Plan migration approach per database (snapshot restore, DMS, or native replication)
- Create target RDS instances in new accounts via IaC
- Migrate data with minimal downtime
- Update application connection strings
- Update security groups and IAM policies
- Verify data integrity and application connectivity
- Decommission old instances after validation
Open questions:
- What is the acceptable downtime window for each database?
- Which databases require zero-downtime migration?
- Are there cross-database dependencies to consider?