Allow comparing/synching static data from source control
Currently when you try and publish static data, it only supports comparing the data in the source database, there is no option to use source control. Can it compare directly with source control and be limited to only the tables that are configured for static data?
Closing as the request is 5 years old.
Yes, this is currently a limitation in the current SSMS integration. A workaround is to 'get' the relevant source controlled scripts folder version to a temporary location on your hard disk and load this as a scripts folder into SQL Data Compare. In the coming weeks we plan to integrate this into SSMS as we've done for source controlled schema.