Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control: Static Data

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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?

12 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Kieron O'Connor shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDavid Atkinson (Product Manager, Redgate) commented  ·   ·  Report

    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.