I'm trying use beanstalk http://beanstalkapp.com/ and connect it to my DB using SQL Developer tool for version control purposes. In my SQL Developer, the structure of my source code is packages, procedures, functions ... etc. I have two questions in this regard:
1) I'm trying to follow the steps in the second answer here (oracle - SQL Developer source control option - Stack Overflow) by Steve Pettifer. However, I'm stumbled at the step
"
Adding Files to repository.
.......
- In the Files tab, expand My Computer and select the folder which contains the files to be added.
"
My understanding is that the files are already stored somewhere in the server or the computer, and I can add them to the repository. However, what I could not understand, are these files the original source code (packages, stored procedures) that are part of my DB? Or local files that are stored or exported manually?
In case they are the original source code, where can I find them ? In other words, where in my server directory can I find all packages, functions, and stored procedures?
In case they are local files (not part of the DB), then what is the point of adding them to the repository and track the changes on them. After all, they are not reflecting the real code running on the DB?
2) In all SVN I see branches, trunks, and tag: What is the suitable files structure should I use for this? In other words, I have few schemas, should I store each schema in a branch? Or separate repository? How about functions and procedures?
I hope my questions are clear. Please ask to clarify anything vague, and many thanks in advance for your help.