SCA Migrations SSMS VS
bitman
Posts: 8 New member
Hello,
I followed the video tutorials from the university, specifically the Getting started with SQL Change Automation with Migrations, and I was able to create an SCA project successfully with my large database. I was able to load them in Visual Studio and SSMS. Both shadow databases for my DEV and TARGET databases were also generated.
My next steps were to make some changes to the data by updating an existing record for a single column in a table as well as adding a new record in the same table. I did this in my DEV database. But after doing so, I tried refreshing my project in both SSMS and VS but it says there were no changes to the development source.
Am I missing something?
I followed the video tutorials from the university, specifically the Getting started with SQL Change Automation with Migrations, and I was able to create an SCA project successfully with my large database. I was able to load them in Visual Studio and SSMS. Both shadow databases for my DEV and TARGET databases were also generated.
My next steps were to make some changes to the data by updating an existing record for a single column in a table as well as adding a new record in the same table. I did this in my DEV database. But after doing so, I tried refreshing my project in both SSMS and VS but it says there were no changes to the development source.
Am I missing something?
Tagged:
Answers
In order for changes to be detected in the data inside the table, you need to add the table as a "Static Data Table". This indicates that you'd like to version control the data.
This can be done in either Visual Studio or SSMS. This article shows how it works in SSMS and also links to some helpful resources: Using SQL Change Automation in SSMS to Track Static Data Changes - Redgate Software (red-gate.com)
Hope this helps,
Kendra