Remove columns in comparison but not in synchronization
AndersL
Posts: 5
Hi
I'm merging several databases into one large.
Is it possible to remove columns in comparison but not in synchronization?
I have columns such as ChangedOn and ChangedBy that I don't want to compare. But in the INSERT's generated by Data Compare synchronization I need to have values for these columns. The original values or some defaults will do.
I could always edit the generated sql manually, but I'll be glad if the tool could do that for me.
I'm merging several databases into one large.
Is it possible to remove columns in comparison but not in synchronization?
I have columns such as ChangedOn and ChangedBy that I don't want to compare. But in the INSERT's generated by Data Compare synchronization I need to have values for these columns. The original values or some defaults will do.
I could always edit the generated sql manually, but I'll be glad if the tool could do that for me.
Comments
This feature has already been requested several times and we are hopefully looking to include it in a future release.
The feature request ID is SDC-778 if you'd like to chase it up in the future.
Thanks
Siân Williams
Red Gate Software
Tel: 0800 169 7433
sian.williams@red-gate.com
Meanwhile I've added some defaultvalues in my tables.
/Anders