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%'.
![](https://secure.gravatar.com/avatar/024412491a7906a17aa4e16bf208cd3b?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
kkam commented
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.