We are using the Toad modeler and Oracle as our database development environment. There are several enviornments(development, testing, production), we have multiple release working in parallel. For example, there may several drops for each Release in development environment, we need to consolidate these into one drop to testing environment. Meanwhile, we would like the keep the consistence between the model and the production database. We are using SVN as the version control system.
Toad modeler has the function of reverse enginnering, generate DDL, merge model and etc, which makes it a good tool for such development. Is there any best practice of the procedure or toturial for such database development using Toad modeler, version control and database system?