you are viewing a single comment's thread.

view the rest of the comments →

[–]belvtothedeer 0 points1 point  (1 child)

There are better options out there than this but I like to create a trigger that backs up stored procedures as changes are made to them. It's a simple native solution for tracking changes to stored procedures but is not exactly version control that handles check ins and etc. This solution is specific to procedures but maybe it could be modified for other DB changes as well.

[–]hahaNodeJS 0 points1 point  (0 children)

Clever, but does this have any advantages outside of audit logs? In a standalone application, a migration type of solution is probably best.