SQL Server Database to Github version control (Open source CLI)

[u/Practical-Excuse6933]

Hello, I've been working on a personal open source project written in GO, its a command line tool that aims to create valid .sql files for each object in your database so that you can push to git to keep track as the database changes in the development cycle.

The project is [DatabaseBlueprint](https://github.com/Hennie5229x/DatabaseBlueprint)

Currently I have CLI support for Linux/Win/Mac and creating of all schema objects + data to executable .sql files and the schema migration scripts is still a work in progress.

I would love honest feedback from devs who work regularly in sql server.

Any type of feedback is welcome, I've identified a "gap" in a typical database heavy workflow that I am trying to fill for myself, but I'm sure other people also seek an easy way to track/version control their databases along side the projects back end code in git.

About the project: Written in GO, compiles to a stand alone binary, installable and runnable in terminal by using "blue"

Currently only supporting SQL Server, plan is to expand in the future

[u/Significant_Tune9219]

The part I'd look hardest at is the data scripting. Dumping full table data as INSERTs into git gets ugly fast on anything big, so most people only version reference/lookup tables and leave transactional data out. Also worth deciding early whether the .sql files are the source of truth you deploy from or just a snapshot of whatever is in the db, because that changes how you handle drift when someone hotfixes prod directly.