Retrieving Schema - Registering Databases

JamieAJamieA Posts: 12
edited July 28, 2011 8:03AM in SQL Data Compare Previous Versions
Hi, I am trying to run data compare 9 with a database being compared to a backup. The backup sets registered fine, but on the second tab, "tables and views", it is just sitting there saying "Retrieving Schema Registering Databases 0%". The backup is about 2 gigs. It has been running for 15 minutes. Is this behaviour normal, or do I need to do something?

Hope you can help,


Jamie
· Share on Twitter

Comments

  • JamieAJamieA Posts: 12
    It just required patience - I just checked back and it has sorted itself out.

    It's probably because too much metadata was being compared - I am new to SC9, must suss out the project options!

    Jamie
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,455 Rose Gold 2
    Can I ask what your use case is? You might want to look at SQL Virtual Restore as an alternative mechanism to query a backup. It's faster and provides you an actual database you can interact with.
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • JamieAJamieA Posts: 12
    Yes - that would be the tool for the job - but it's not installed on this server :(
    · Share on Twitter
Sign In or Register to comment.