Is it possible to change the family_guid in MSSQL?
I have encountered the exact same scenario as you - many DBs all based off a template, and all need to go into RDS.

AFAIK there is no way to change the underlying family_guid in a simple command.
However, using the .bacpac export/import will assign a new family_guid to the imported DB. Sadly you can't directly import a .bacpac into RDS (the import fails, and you can't delete the database!)

So, as a work around, I ended up with the following process:


Create a .bacpac (contains both data &amp; schema) of the original DB.
Import that .bacpac into a staging database (could be LocalDB, or another instance somewhere, or even the same instance as the original DB).
Create a traditional backup (.bak) of the staging DB.
Upload the backup to S3.
Run the msdb.dbo.rds_restore_database command on the S3 backup file.


Quite a process for what should be a simple task!