I am trying to play around with source control using Azure Data Studio and SSMS.
Right now I have connected my sql db and cloned my git repo from devops to Azure Data Studio
As you can see in the above screenshots, the first one is the connector to my sql db and the second one shows that I have already tried some source control tests etc.
What I am trying to figure out now.. I want to apply an alter table alter column command to a certain column to 50 tables in my db. When I run the script on my connected server I am able to make the changes. Now what I am trying to find out. If I run the script and make the change, is there a way for source control to capture this change so that I can push it to my remote repo?
Some context, I have a column that is being used in 50+ tables. I need to update the data type for this column. I want to find out if I can use Azure Data Studio to run the script that can change the data types for all tables and then recognizes that change and stores it in the source control. That way I wouldn't have to make the change 50 times manually in my remote repo....