In our environment we refresh our dev and QA databases from our production environment about every 6 months. We have a variety of Oracle 9i and 11g databases. We are interested in using Team Coding but, if I understand it correctly, the Team Coding objects are installed directly on the database. If the database is refreshed I would expect that the Team Coding objects would be destroyed during that refresh.
My quetions are:
- Am I right about the Team Coding objects?
- How do other shops deal with database refreshes and Team Coding?
- If the objects do get destroyed during a refresh, if they are re-installed post refresh is anything lost with regards to Team Coding? I understand that the objects themselves are saved to a source control system, we use Subversion, but from the database perspective is there any loss?
A little more detail about our environments:
- We work in a variety of 9i and 11g databases
- We currently use Subversion for source control of our database files (packages, procedures, ad hoc SQL, etc.)
- The developers work on Windows 7 machines for development with a unix environment supporting our databases and any scripting needs.
- Database refreshes are based around Snap/Clone technology (intentionally vague because my team doesn’t really understand that)
If I am unclear in my question or I am not understanding Team Coding correctly, please let me know.
Thanks in advance for a kindly response.