Creating production database environment from development environment in Oracle
Posted on 2014-09-09
I have a question about our Production database environment. We have been developing our application and database in a DEV environment. Once the lead developer felt he was ready to move the application to the next step, we did a backup and restore of the DEV database and moved it to TEST envrionment. Now we have people testing the app and we are fixing any issues, etc.... My question is, what is the best way to move our latest database code to our PROD server? I have my own suggestions but the developer has another and I would like to know what the Experts think?
100s of tables
100s of procedures
100s of views