Please consider this as an enhancement:
We are using Visual Source Safe for version controling. We would like to be able to set custom handler (procedure) which produces the DDL of the objects.
i.e.: SQL Navigator produces .IDX file in the VSS which contain simple “create index” statement, but for build purposes we would probably implement something like this
execute immediate ‘create index blah on YYY (n) tablespace XXX …’;
exception when others then
if sqlcode <> -00955 then – ignore “name is already used by an existing object” error, index is already present
Similarly there would be customization for just about every object type … ADDING TABLE COLUMNS, etc…