SQL Database Project - Difficult to maintain

Question

Hi All,
I am very new to SQL world and recently I implemented CI CD for database project as well. But, I found that it is very difficult to maintain database project with azure git when there is large team working on database OR doing development on SSMS and maintaining project check in with SSDT , most difficult when we need to rename or delete which generate refactor logs, remember which columns changed to check in correctly.

I really need solution for this.
Is there any solution with which I can directly connect SSMS to azure git repo ? OR please provide some efficient solution with details

Answer 1

Hi @leo-3429 , welcome to Microsoft Q&A forum.

You can use Azure Data Studio that supports Git for version/source control. You can refer to article for more details.

For step by step process, you can refer any of below article for the same.

Source Control using Azure Data Studio and GitHub

Source Control using Git in Azure Data Studio (ADS)

Please let us know if this helps or else we can discuss further on the same.

----------

If answer helps, please mark it 'Accept Answer' as it could help others having similar queries.

Answer 2

@leo-3429 Thank you for reaching out.
Developers are expected to check in the changes from development environment into the database project solution.
However, I agree that this could be a challenge sometimes.

You can use the schema compare within Visual Studio to generate a diff between the dev and QA/Prod database.

This will identify all changes that need to be promoted from dev environment.

Please let us know if you have further questions.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.

Answer 3

You should stop making changes to the db with SSMS,
or only make changes to local DB copies,
then import those changes in a different branch and merge this with a pull req into the main branch .