Skip to content
← SQL Data Compare

How can we improve SQL Data Compare?

SQL Data Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Project level variables / merge fields

We use data compare to run a sync of lots of data across many tables all linked to a specific organization in a multi-tenant db.
It would be great to be able to define a variable at the project level, e.g. InstanceID, then be able to set a sql comparison to InstanceID = [InstanceID] (or @InstanceID). That way we could copy a project and just edit the InstanceID instead of going into 30 definitions and changing every ID. Would be most useful as a simple text replace, so we could use "between 1 and 2" or like 'abc%'.

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Scott Simpson 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
  • kkam commented  ·   ·  Report

    This is an absolute need.

    Without this we are often having to forego "Data Compare". With the length of time this product has been released I am surprised that feature is still lacking.

    I've started looking into IDERA and others to see if I can find another toolset that would offer this functionality for my team.