Removing old database scripts

We use our database script system for already quite a while and recently we started using our SQL abstraction layer for writing database scripts. However old database scripts still use literal SQL queries. To get those queries updated we have two options. Either we rewrite those queries or we remove them altogether.

I suspect removing old database scripts would be the easiest solution. We should be able to determine a script up to which all previous scripts can be removed. At least the could be removed. The remaining scripts could be rewritten to use the SQL abstraction layer. Does everyone agree to remove old database scripts? And if so, does anyone know a script before which all scripts can be removed safely?

Berichten

I propose to remove the old scripts. The oldest application we have running is Charta Web. The last script run on the live server is 247, therefore we can probably remove all scripts up to 247. There is a check active that compares the script entries in the database to entries in the code. It is quite handy to trace differences in databases, so keep in mind that we need to use this check (on old scripts too) for the next releases of applications.

All scripts up to 247 are removed now and everything still seems to work fine. Removing the old scripts solved quite a few deprecated SQL calls.