Sync'ing flattened data.

Automate and integrate using the SQL comparison API

Sync'ing flattened data.

Postby MarkLFT » Fri Apr 22, 2011 4:18 am

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.

Posts: 10
Joined: Fri Apr 22, 2011 3:59 am
Location: Bali, Indonesia

Sync'ing flattened data

Postby Sian.Williams » Mon Apr 25, 2011 11:20 am

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
Posts: 32
Joined: Thu Aug 26, 2010 8:59 pm

Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests