Spins infinitely Retrieving schema and Registering Databases

rvaiyapurirvaiyapuri Posts: 5
edited September 16, 2013 4:20AM in SQL Data Compare Previous Versions
I have a requirement like this -

I have a production database on which I have 5 major views which need to be compared against the same kind (same view structure) in the development environment.

I tried to retrieve the schema and it just keeps on spinning and I see no progress. Please let me know if the database schema are different, can't we compare specific tables and views alone with SQL Data Compare?

Please help!
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    Hi,

    There's no obvious reason why it would get stuck reading the schema, but there's a couple of things to try:

    - firstly, ensure you're connecting using an account with sysadmin permissions to eliminate any security problems.

    - if that doesn't help, can you try SQL Compare- does that successfully read the schema or does it get stuck/crash?
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • rvaiyapurirvaiyapuri Posts: 5
    I tried using SQL compare and it gets stuck there as well.
    · Share on Twitter
  • James BJames B Posts: 1,124 Silver 4
    We'd probably need to see the database to understand why. is it possible to obtain a backup? If so, you can mail to support@red-gate.com quoting F0071697 in the subject line.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • scotteb@mindspring.comscotteb@mindspring.com Posts: 16 Bronze 2
    @rvaiyapuri,

    I also experienced this and was able to resolve this issue by creating a new project. My project had other symptoms of corruption, maybe your project has only a minor corruption causing this. Try creating a new project and see if it loads more quickly.

    Best,
    Scott
    · Share on Twitter
  • robinphrobinph Posts: 1
    Just to add to the post, I had the same issue. Turned out a colleague had restored the test database and wiped out my access. So, SQL Data Compare could not access the database. I needed to refresh the Logins in SQL Management Studio to see that I was no longer a user. Might also have helped if SQL Data Compare pointed this out too. Now a little bit wiser.
    Robin Humberstone
    · Share on Twitter
Sign In or Register to comment.