More information would be helpful to properly advise here. Such as knowing if you own both accounts, the database engine used, the database size, if the region stays the same, if there can be downtime or not, if the encryption key should be the same...
You can copy an encrypted Aurora cluster snapshot across account: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-copy-snapshot.html#aurora-copy-snapshot.Encryption, then scroll to "Copying a DB cluster snapshot across accounts" and "Copying an encrypted DB cluster snapshot to another account".
I might not be clear on your requirements so hopefully the information above helps.
You can't share a snapshot that's encrypted with the default AWS KMS key. You must create a custom AWS KMS key instead.
- You can refer to the below document
How can I share an encrypted Amazon RDS DB snapshot with another account?
How can I share an encrypted Amazon Aurora snapshot with another account?
If above doesn't works for your case then you can explore the DMS option.
- Using AWS Database Migration Service (DMS):
AWS Database Migration Service (AWS DMS) is a web service that you can use to migrate data from a source data store to a target data store and you can replicate ongoing changes to keep source and target databases in sync. You can choose the supported source and target DB as per your requirement.
[+] Getting Started with AWS DMS - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_GettingStarted.html
[+] How AWS Database Migration Service works - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.html
- asked 2 months ago
- asked 2 months ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 months ago
- EXPERTpublished a month ago
- EXPERTpublished 2 months ago
Thanks for reply, Yes both accounts are owned by me with security policy in place, DB engine is Aurora PostgreSQL with size around 12GB, regiion will be same.. there can be down time. Encryption key's can be same.