Version Control for Oracle Database objects
Posted on 2011-03-11
We recently installed Microsoft Team Foundation Server(TFS) and we would like to use for Version Control of the source code for the Oracle Database objects.
Am kind of new to this whole process. I understand that we will have to checkout the previous version and check-in the latest one.
Can someone guide me how we can put packages in the TFS. Do we have to put the package specification and package body together as a script or each of it seperately.
I have this question because..
Eg: What if I have added some public variables in the package spec and that variable is not being used in package body.. then can I check-out only the package spec not the package body.
Another qn: If I make changes in the procedures in package body, can I check in script the package body only.. for this to happen, do I have to maintain procedures/functions in the package bodies separately or should I maintain the whole package body script together.
Your valuable suggestion is appreicated. Please help. Quick reply is appreciated!