Data Compare won't see my views

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Data Compare won't see my views

Postby wdhenrik » Tue Jul 16, 2013 12:16 am

The Tables & Views tab (and Object Mapping tab) in SQL Data Compare doesn't list any of my views. Is this intentional?

I'd really like to be able to use a view to compare some data as there is no natural comparison key available otherwise.
wdhenrik
 
Posts: 12
Joined: Thu Jul 19, 2012 11:58 pm

Postby eddie davis » Tue Jul 16, 2013 9:51 am

Hi, thank you for your forum post.

By default, the option to compare views is disabled.

To be able to compare views, you need to Edit the Project ->Options tab ->Enable the 'Include Views' option. You will then be able to compare views and select them through the 'Tables & views' tab.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Data Compare 10

Who is online

Users browsing this forum: Bing [Bot] and 0 guests