Re: Method for migrating schema from PROD to DEV

From: Andre van Winssen <>
Date: Tue, 25 Nov 2008 12:12:12 +0100
Message-ID: <>

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.


Received on Tue Nov 25 2008 - 05:12:12 CST

Original text of this message