Data Compare won't see my views

wdhenrikwdhenrik Posts: 15 Bronze 1
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.

Comments

  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    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
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.