3 ms·
Yes, there are tools to do this. It varies by database server and may need custom integration with your deployment system but they definitely exist. The altern
by sitharus 10y ago
Yes, there are tools to do this. It varies by database server and may need custom integration with your deployment system but they definitely exist.
The alternative is the old StoredProc_v1, StoredProc_v2 etc in the database and have the application check what's available. This allows you to roll the parts independently.
The big advantage with stored procedures is they can benefit from the DBMS caching and applying additional optimisations (depending on the DBMS of course).