Sync'ing flattened data.

[MarkLFT]

I have a database that contains a flattened version of two tables in another database. i.e. in Src table there is a operatorDef table, and an operator rights table. In the destination table there is a operatorDef table which is almost identical to the src OperatorDef table, but has an extra field AccessAllowed. This extra field is a boolean, and is set to true or false based on where a value exists in the operator rights table.

I can easily distill the source tables down to a single view, but can I then sync that view to a table?

Any and all advice would be greatly welcomed.

Thanks

[Sian.Williams]

Thanks for contacting Red Gate.

If you set SQL Data Compare to include the view and not the table, you can then update the table through the view.
_________________
--------------------------------------
Siân Williams
Red Gate Software
Tel: 0800 169 7433
sian.williams@red-gate.com
--------------------------------------