I was this guy years ago in a waterfall style shop. We were a SQLServer c# all MS vertical and we did just this.

All stored procedures, table definitions, etc were checked in. There was a whole release process and QA to bundle the right versions of things into deployables which I did. It didn’t work flawlessly but it worked and when it failed it was straightforward enough that figure out why was easy.