Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control: Static Data

Categories

JUMP TO ANOTHER FORUM

(thinking…)

some extended property or search item or project option to “link” static data tables ONLY – this would be a huge time saver.

We have thousands of tables (some with millions of rows) with only 90-100 static data tables.

At the moment, I have to edit the project; untick all then tick 90-100 manually which is very time consuming.

If there was some extended property or search item or project option to “link” static data tables ONLY – this would be a huge time saver.

Thanks for your response.

Regards

11 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…)
Anonymous shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

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
  • Trevor commented  ·   ·  Report

    I too have this problem. Manually ticking/unticking is time consuming.
    I have edited the sdc file as XML and played around with changing the options to suit but really should be a feature in SQL Data Compare.

  • Daniel White commented  ·   ·  Report

    I assume you're talking about SQL Data Compare; this doesn't make much sense if you're talking about SQL Source Control. I have the same problem; I want to start SQL Data Compare, pick my databases, and have some way to automatically check just the tables that are configured as static data in SQL Source Control.

  • Mark commented  ·   ·  Report

    I achieved the desired results by a custom powershell script but agree this should be an option.