Hi @Grant Fritchey thanks for your reply, we are moving towards backup and restore on AWS RDS but in the meantime I need to use this procedure, can you tell me , how to check if all the FKs are enforced on the primary db, and if not how to enforce them. I also need as you said the query to check i some of them are disabled. Thanks.
The RDS version of backup and restore has some serious issues. For example, look into how to restore a single database. Surprise!
You might also want to look into what the DBAs will have for privs... Surprise! again!
Then, compare the cost of RDS to EC2. SURPRISE!
And if you ever think you want to change a database from the FULL recovery model to Bulk Logged or Simple? SURPRISE, SURPRISE, SURPRISE!
Then, there's the occasional downtime for upgrades that you can't really control that much.
Oh... and you want to have the Developers edition on Dev and QA instances to legally save on licensing costs? SURPRISE!
Heh... RDS... the "gift" that keeps on takin'.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)