Red Gate forums :: View topic - Selective compare on large database
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

Selective compare on large database

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



Joined: 25 Sep 2008
Posts: 6
Location: Boston, Massachusetts, USA

PostPosted: Wed Jun 11, 2014 3:25 pm    Post subject: Selective compare on large database Reply with quote

It would be very nice to be able to compare only certain types of objects on a large database. I support a database with over 10,000 tables, views, stored procedures, functions, and accounts. I regularly maintain views used for reporting which always begin with "v_" because none of the vendors code begins with the letter "V" and an underscore. I would like to compare only views starting with "v_".

Comparing the whole database is time consuming and more cumbersome to work with then it could be, when I'm concerned with a tiny fraction of the whole.
_________________
AlanCHB
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 84

PostPosted: Fri Jun 13, 2014 9:18 pm    Post subject: Reply with quote

Hi aspillert,

Thanks for the post. In your particular situation, there are a few options available that you can try to tackle this scenario.

First possibility:
- Create a filter that contains a rule that includes just views that start with v. Here is an article about setting up filters:
https://documentation.red-gate.com/display/SC10/Using+filters

- once the filter is setup you can then save the settings as a project and then the next time you want to run the comparison you can setup a cmd line job to run sql compare and make use of the project file

Second possibility:
- create a command line job that makes use of the /include(or vice versa the /exclude switch) to include just certain object types or object names in the command. Here are some more details about setting up the command line:
https://documentation.red-gate.com/display/SC10/Switches+used+in+the+command+line

Along with these different solutions, it is also important to note that which ever method you go with, part of the designed behavior of SQL Compare is that it will need to register each database source each time a comparison is run. The number of objects in a database source can increase the amount of time it takes to process a comparison. This database registration is a required step of the application so that it can understand the current state of your database schema and dependencies.

I hope this helps.

Best Regards,
Steve
_________________
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
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