Red Gate forums :: View topic - Spins infinitely Retrieving schema and Registering Databases
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

Spins infinitely Retrieving schema and Registering Databases

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rvaiyapuri



Joined: 12 Apr 2013
Posts: 4

PostPosted: Fri Apr 12, 2013 1:03 am    Post subject: Spins infinitely Retrieving schema and Registering Databases Reply with quote

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!
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Fri Apr 12, 2013 2:41 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
rvaiyapuri



Joined: 12 Apr 2013
Posts: 4

PostPosted: Fri Apr 12, 2013 7:49 pm    Post subject: Reply with quote

I tried using SQL compare and it gets stuck there as well.
Back to top
View user's profile Send private message
abaogamegood



Joined: 17 Apr 2013
Posts: 1
Location: ameirca

PostPosted: Wed Apr 17, 2013 7:29 am    Post subject: cheap rs gold Reply with quote

You can communicate with many friends, maybe you can find the best answer


__________________
The good life on their own to create
cheap rs gold
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Thu Apr 18, 2013 4:11 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
scotteb@mindspring.com



Joined: 13 Aug 2008
Posts: 7
Location: Texas, USA

PostPosted: Mon Apr 29, 2013 1:14 pm    Post subject: Reply with quote

@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
Back to top
View user's profile Send private message
robinph



Joined: 16 Sep 2013
Posts: 1
Location: Hong Kong

PostPosted: Mon Sep 16, 2013 9:20 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group