Version control for PL/SQL. Which is the best approach?
We are developing a quite complex system which involves several
pl/sql packages, some triggers and stored procedure. We have a
version control system (StarTeam) in which we can store the
history of each change at our pl/sql code.
The problem is: which is, in your opinion, the best way to "mark"
a version in pl/sql? For example I putted a costant in a package
interface named "Version=1" which I increment for each new
release; but what about trigger and stored procedure? I need a
system, as simple as possible, which allows a customer to query
the database and tell us "which version" of the overall system
(package+trigger+proc) he/she has.
Thanks in advance
Nicola Farina