Re: Method for migrating schema from PROD to DEV
- From: "Andre van Winssen" <dreveewee@xxxxxxxxx>
- To: JEREMY.SHEEHAN@xxxxxxx
- Date: Tue, 25 Nov 2008 12:12:12 +0100
Hi Jeremy,
No matter which method you use for copying, there are some info security
angles also that you should consider.
- it's not a good idea to develop on a production database (in case your
DEV schema is in the same database as PROD). Also, in that case if you'd use
public synonyms or other global objects such as DIRECTORY's, things can get
complicated and dangerously mixed
- copying production data to development means
endangering confidentiality of that production dataset
best be to run DEV in a separate database and use some datamasking mechanism
to protect production data. GC 10.2.0.4 has a licensed pack for it but with
some effort you could write a simple one for your own purpose.
--
regards,
Andre
Other related posts:
