Options

Does SQL Compare compare Database Views?

jonswainojonswaino Posts: 18
edited July 24, 2008 2:46PM in SQL Compare Previous Versions
Hi,
I currently am using the evaluation version of SQL Compare.
However it doesn't seem to be comparing Views between both database. I would expect to see views either in the differences pane or equals pane?
· Share on Twitter

Comments

  • Options
    jerryhungjerryhung Posts: 138
    It DOES compare views in my compare projects

    My view was SCHEMABINDING but I don't think it mattered
    It also picked up the index I built on the view (indexed view)
    Jerry Hung
    DBA, MCITP
    · Share on Twitter
  • Options
    shadowbobshadowbob Posts: 71 Bronze 2
    Yes, Compare will compare all types of views (schemabinding or no), along with any indexes. Compare should compare every database object. Good luck with your evaluation!
    Jeremy Fuller
    VP, Software Development
    Organizational Intelligence, Inc.
    · Share on Twitter
Sign In or Register to comment.