How can we help you today? How can we help you today?

Spins infinitely Retrieving schema and Registering Databases

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!
rvaiyapuri
0

Comments

5 comments

Sort by
  • James B
    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?
    James B
    0
  • rvaiyapuri
    I tried using SQL compare and it gets stuck there as well.
    rvaiyapuri
    0
  • James B
    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.
    James B
    0
  • scotteb
    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
    scotteb
    0
  • robinph
    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.
    robinph
    0

Add comment

Please sign in to leave a comment.