Method for migrating schema from PROD to DEV
Date: Mon, 24 Nov 2008 16:12:03 -0500
Does anyone have a proven method for migrating a schema from PROD to DEV? I plan on using export/import, but I've got a few reservations about the migration steps.
I think the best method would be to do the following
- Export Schema in PROD
- Export Schema in DEV (for backup)
- Drop user in DEV
- Create basic user in DEV
- Import user in DEV
- Verify object count - PROD vs DEV
- Compile schema
Does this sound right?
P Consider the environment. Please don't print this e-mail unless you really need to.