Database – development using virtual machines
I have recently been given the role of managing or developing the environment, including:
>To manage the version control system (subversion), we usually have a main branch, which is released every 6 months and a maintenance branch every two months to repair non main errors found by users and some branch related errors. For those errors that cannot wait for the maintenance version. > Manage our database so that we have a development database for each branch of the code
We soon turned to version control and encountered the following problems:
>Developers working on multiple branches at the same time usually end up developing the wrong database (we have about 15 developers) > lack of an appropriate strategy to manage the release of branches to production and propagation back to other branches > lack of an appropriate strategy to manage the database associated with each branch (that is, we should keep the script consistent with the production environment, and then the script to make each database user meet the needs of the branch)
I have thought about using virtual machines for each branch of the code (i.e. VM containing Oracle express database users, ColdFusion administrator with data source and other correct settings, and development tools such as IDE and tortoise)
I am looking for any suggestions that anyone may have to help solve these problems because I find it difficult to manage this process I know no two companies have exactly the same settings, but I welcome any help
Solution
I think the best solution for you is to start using continuous integration applied to the product lifecycle strategy
> Continuous integration > Great open-source framework for continues integration!
I hope this will help you, but your question is difficult to answer. Because there are many parameters to answer, these parameters are always very important to the company. You should consider hiring a consultant to help you He / she must come to your company and help you decide and implement