Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control: Static Data

Categories

JUMP TO ANOTHER FORUM

(thinking…)

SQL Source Control Configuring Data Compare Options

Make it possible for us to configure how SQL Source Control does its data compare. There are some great settings that work within SQL Data Compare 10 that allow a user to configure how data in each table is compared between data sources. Currently the main feature I want is to allow the selection of table columns to actually compare (i.e. one column is an identity field which isn't always the same).

34 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…)
Christopher Strub 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
  • Michael Melancon commented  ·   ·  Report

    And also to re-enable constraint checks. It's extremely annoying to have to go back and remove 'WITH NOCHECK' from every table when there is a data change.

    Why would anyone want the default to be to leave their database with all contraints disabled?? I have them there for a reason...

  • John Price commented  ·   ·  Report

    We'd like this too. We frequently have something like a Site table where the list of sites is static but the URL for the site varies by environment. We can exclude the URL columns when making scripts via SQL Data Compare, but for developer SSC check-ins they have to remember to not check that table's data in.