A simple code source control for SQL Server

If you use code objects like stored procedures or views on SQL Server, you will probably wonder how to save the code changes for source control. What happens if we want to go back to an earlier version, or just compare the current production version with the previous one?

You can use the full Microsoft source control with Visual Studio. See Eitan Blumin's blog for more details: https://eitanblumin.com/2024/08/13/t-sql-tuesday-177-managing-database-code/

But if you want a lightweight solution, that just keeps versions of your code changes to SQL objects (Stored Procedures, Views), see this simple solution on my blog: https://chenhirsh.com/a-simple-code-source-control-for-sql-server/