Data Compare won't see my views

wdhenrik

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.

Eddie D

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