What are the challenges you face when working across database platforms? Take the survey

Sync'ing flattened data.

MarkLFTMarkLFT Posts: 15
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.



Sign In or Register to comment.