Red Gate forums :: View topic - Pre-Comparison Filtering?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Pre-Comparison Filtering?

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
raymond.dazo



Joined: 28 Apr 2010
Posts: 3

PostPosted: Wed Apr 28, 2010 7:01 am    Post subject: Pre-Comparison Filtering? Reply with quote

Hi Red-Gate Team,

We have a very important task that we need only to compare a limited number of database objects against the source database. Red-Gate does compare every objects first before you could filter the objects to sync, thus the post-comparison filtering.

One of your support posted something about pre-comparison filtering:

http://www.red-gate.com/messageboard/viewtopic.php?t=8803&highlight=filter

I would like to ask what is Red-Gate's plan regarding this, would your team implement a pre-comparison filtering? If so, when would be the target date?

Regards,

Raymond Dazo
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Wed Apr 28, 2010 10:00 am    Post subject: Reply with quote

Hi,

Thanks for the question.

Can I ask which database version you are developing on? For SQL Server 2000 and 2005 we need to read the entire databse to build a dependency tree. For SQL Server 2008, because we it holds accurate dependency information we could in theory provide pre-comparison filtering. There is no timeframe for when this might be, and it would depend on the extent of SQL Server 2008 adoption as well as customer demand.

Is post-comparison filtering not fast enough for you at the moment?

David Atkinson
Product Manager
Red Gate software
Back to top
View user's profile Send private message Send e-mail
raymond.dazo



Joined: 28 Apr 2010
Posts: 3

PostPosted: Wed Apr 28, 2010 10:24 am    Post subject: Reply with quote

Our product's min requirement is SQL Server 2005 and our existing clients have been using this version.

There's a big performance difference when comparing the full size source database against a trim down target database (where our selected objects are stored).

For example:

We have a full size source database which 3gb in size. Then we have a trim down version (target DB) which is 441mb only. All objects (including the dependencies) in the latter database can be found in the source database.

Comparing the trim down db against the full size source doesn't eat that much time but it's the time registerting the full size source that eats a lot of time.

The larger the database is the longer it takes to register.

Oh, I guess I just realized what's the main issue that we have with your product. I think regardless if you were able to implement the pre-comparison filtering on whichever version of SQL Server, it's the time to register the full size database that kills.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Wed Apr 28, 2010 10:56 am    Post subject: Reply with quote

Yes, the number of schema objects will impact the registration time. Have you got plans to upgrade to SQL Server 2008? If so, I suspect you'll achieve better performance.

David
Back to top
View user's profile Send private message Send e-mail
raymond.dazo



Joined: 28 Apr 2010
Posts: 3

PostPosted: Wed Apr 28, 2010 11:02 am    Post subject: Reply with quote

Does upgrading to SQL Server 2008 will improve registration performance? And how much improvement?
Back to top
View user's profile Send private message
Simon C



Joined: 26 Feb 2008
Posts: 140
Location: Red Gate Software

PostPosted: Wed Apr 28, 2010 11:46 am    Post subject: Reply with quote

In SQL Server 2008 we don't need to parse textual objects to load dependency information, we read sys.sql_expression_dependencies instead. So, if you've got lots of textual objects, you will get better population performance with SQL Server 2008

SimonC
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