What are the challenges you face when working across database platforms? Take the survey

Tables linked as Static Data in SSC not recognized in SCA in SSMS

We have been heavily using SQL Source Control to deploy our database changes but now need a way to handle data related changes. I have started creating a SCA project from our SSC database as the source and ran into issue were the static data is not being recognized. I have not found any demos that has SSC project as the source for driving the static data in SCA in SSMS and the "Data" tab in SSMS for SCA does not appear. Our developers and data admins have been the ones to maintain those sql files directly in source control instead of having to request and wait on a DBA to pick up that static data change that is needed. Can SQL Source Control project that has tables linked as "Static Data Table" with sql files already populated with data not be picked up and used by SCA project? 

Best Answers


Sign In or Register to comment.