Sync'ing flattened data.

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

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.

Thanks
MarkLFT
 
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
sian.williams@red-gate.com
--------------------------------------
Sian.Williams
 
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