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 has a licensed pack for it but with
some effort you could write a simple one for your own purpose.


Other related posts: