Data Compare won't see my views

Compares and synchronizes SQL database content.

Data Compare won't see my views

Postby wdhenrik » Mon Jul 15, 2013 11:16 pm

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.
Posts: 12
Joined: Thu Jul 19, 2012 10:58 pm

Postby eddie davis » Tue Jul 16, 2013 8: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 Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1024
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests