I need a program to store the database script for oracle
- by Hakan Kara
We are developing a project that has 3 enviroments (development, test, production)
So there are 3 databases (actually more than 3, because we have 5 customers so we have more than 10 databases) and they must be synchronised. There are 30 coders working for this project. Everone adds, deletes, and changes procedures, table columns etc.
We need a program to store our database scripts like visual studio's team foundation server.
See the change history of script file.
Everyone must access that program and be able to put their scripts.
Recover previous versions of script file.
Execute these scripts over a selected database.
Compare databases by procedures (not only by name, by content of procedure), functions, table columns, packages etc.
I am searching a program like that. Which one do you suggest me?