Hi Vit,
> Hello,
>
> may I ask a question: what would be the best way to achieve this with
> SVN:
>
> Database versioning scripts shall be (1) numbered (due to DBmaintain)
> and (2) incremental.
>
> ad 1) When a developer commits a script, I should get the next higher
> number
> than the last committed script. E.g. 045_customers.SQL, 046_orders.SQL
> etc
>
> ad 2) Scripts, which are once committed, should be immutable --
> developers
> should not be able to change them. They can only add new scripts.
>
> Many thanks in advance,
> V. Prochazka
Both should be achievable using pre-commit hooks. You can add a check to
ensure consecutive numbering of your SQL-script files as well as
preventing any modifications to committed files.
--
Regards,
Stefan Hett
Received on 2016-03-31 12:02:56 CEST