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

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Retrieving Schema - Registering Databases

 Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
JamieA



Joined: 28 Jul 2011
Posts: 9
Location: United Kingdom
PostPosted: Thu Jul 28, 2011 10:58 am    Post subject: Retrieving Schema - Registering Databases Reply with quote
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
Back to top
View user's profile Send private message AIM Address
JamieA



Joined: 28 Jul 2011
Posts: 9
Location: United Kingdom
PostPosted: Thu Jul 28, 2011 11:26 am    Post subject: Reply with quote
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
Back to top
View user's profile Send private message AIM Address
David Atkinson



Joined: 05 Dec 2005
Posts: 1079
PostPosted: Thu Jul 28, 2011 12:24 pm    Post subject: Reply with quote
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.
Back to top
View user's profile Send private message Send e-mail
JamieA



Joined: 28 Jul 2011
Posts: 9
Location: United Kingdom
PostPosted: Thu Jul 28, 2011 1:03 pm    Post subject: Reply with quote
Yes - that would be the tool for the job - but it's not installed on this server Sad
Back to top
View user's profile Send private message AIM Address
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