Show my version control system as an environment
I want to check that our dev server is in sync with version control. I want to show the head of my version control system as an environment, so I can see it side by side
I would like to align my TFS branches with the pipeline. I would hope to see these different states:
1. databases matches source control and DLM,
2. database does not match DLM or source control
3. database matches DLM, but not source control
4. database matches source control, but not DLM (configurable for auto acknowledge DLM)
5. all three are different, database, DLM and source control
If an un-acknowleged database drift matches the current version of the branch, automatically acknowledge the drift changes with the build date as comments.
Why not have it just check into source control for you as you migrate? Not everyone has visual studio, so people could work on DEV database directly, then using the dashboard I can approve schema with a comment, and have it check into source control for me, I could even create a branch mapping for each environment in my pipeline.
+3 for this. Instead of just being able to add Servers to a pipeline, adding a version/source control path would allow us to move to DLM Dashboard exclusively.
I agree with Justin. Would be a great addition.
We use SQLProj files in Visual Studio. MSBuild can generate a dacpac which would be great if we could compare that to the database
Yes this would be a great compliment to our current CI/Deployment process and a great go to place for our daily deployment reviews and scheduling.
How would you imagine this working? For example would you want to be comparing a specific revision (or branch/tag) with your production environment?
Justin Whaley commented
This is exactly what I would use this for. It would be much more useful then only being able to compare changes that have been rolled to a sql server.