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%'.
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.