Copy PROD Database to QA
We would like the ability to copy the PROD database to QA and DEV environments to assist in testing efforts. I'm talking fullscale DB backup/restore so we get an identical environment.
Has anyone been able to successfully do this? If so, would you be willing to provide a procedure? Are there any tables which need to be changed/truncated to identify it as the QA database?
Re: Copy PROD Database to QA
Yes, you can do it as long as you have setup the identical master keys and system credentials in both Prod, QA and Dev