Red Gate forums :: View topic - Filter Compare list prior to starting the Compare
Return to www.red-gate.com RSS Feed Available

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

Filter Compare list prior to starting the Compare

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



Joined: 16 May 2012
Posts: 1

PostPosted: Wed May 16, 2012 7:09 pm    Post subject: Filter Compare list prior to starting the Compare Reply with quote

I would like to be able to filter the compare prior to running the actual compare. There are times I only want to compare stored procedures and I do not want to go through all the tables or other objects.

I recently inherited an application. The databases are set up on 6 servers and none of the databases match even though they are used by the same application. There are tables in some databases that are only data tables used for crunching numbers. There are thousands and I do not need SQL Compare to run through each one - in fact, I get memory errors when trying to run the compare.

It would be useful to be able to compare stored procedures or selected list of tables in order to develop a common structure used by all.

Thanks!
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon May 21, 2012 3:37 pm    Post subject: Reply with quote

Thanks for your post.

I'm afraid we don't offer any pre-filtering in SQL Compare because of the way we need to register the whole schema to understand all the object dependencies.

However, you have not been the first person to suggest the idea, so I've added you as another vote for SC-2471.

You might like to also suggest the idea on our uservoice site as this is a bit more visible and other users can vote on the idea too.

You may also like to vote for the suggestion to make SQL Compare 64bit, as this would probably help with the memory issues you're finding.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
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