we are thinking about using a source control system (like Subversion) for our database development ( Views, SPs, and DML Scripts).
We have 3 different environments, Test, Quality and Production.
What i don't understand:
1. How to handle these environments, should all objects from all environments be scripted out into source control system?
2. What about the deployment of DML Scripts? As far as i know only the schema is stored in source controll, how to handle data changes?
3. What about deployment packages, how can i find out which objects have been changed by deployment 32?
4. How to ensure that verison numbers in different environments match? For example i have 4 versiona of object X(V.1.4) in TEST because i had to make several changes but only the latest version will come to quality, so it will have the number V.1.1. So i could have always different version numbers for each environment (not goof).
Thanks a lot!