Red Gate forums :: View topic - Sync'ing flattened data.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Sync'ing flattened data.

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
MarkLFT



Joined: 22 Apr 2011
Posts: 10
Location: Bali, Indonesia

PostPosted: Fri Apr 22, 2011 4:18 am    Post subject: Sync'ing flattened data. Reply with quote

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
Back to top
View user's profile Send private message
Sian.Williams



Joined: 26 Aug 2010
Posts: 32

PostPosted: Mon Apr 25, 2011 11:20 am    Post subject: Sync'ing flattened data Reply with quote

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
--------------------------------------
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group