I have two large unix boxes running oracle, one in production and one for development. The application is a couple of million lines of C that commicates with another couple hundred thousand lines of PL/SQL (three schemas and about 50 packages in each).
1) Can anyone recommend a version control solution for the PL/SQL code? (Even Oracle’s source control system wants to export the source to flat files and then control those – I would like to aviod that if possible.)
2) How can I keep the data set on the development box in sync with production? An export is going to include the packages and I don’t want ongoing development work to be overwritten.
Thanks,
Maria