Red Gate forums :: View topic - Filtering Questions / Suggestions
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
DTS Package Compare 2
DTS Package Compare 2 forum

Filtering Questions / Suggestions

Search in DTS Package Compare 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
Bernard Sheppard

Joined: 12 Oct 2005
Posts: 39
Location: Melbourne, Victoria, Australia

PostPosted: Mon Dec 05, 2005 12:21 am    Post subject: Filtering Questions / Suggestions Reply with quote

I'm trying to filter the Data Source Name (usually server name for SQL Server connections), so that this difference doesn't show up as a difference when comparing packages between servers.

I've set the DataSource under Connection2 to Show but don't compare, but it still shows as different - under Connections, conn_name, ConnectionProperties, DataSource. It looks like the only way I can filter this is to filter out all ConnectionProperties, which is not ideal.

I don't know if that's because I'm not setting the correct filter item, or there's no appropriatiate filter item other than connection properties, or if it's a bug.

I'd post screen shots if the forum supported it, but it doesn't directly, and I don't have somewhere I can host pictures.

Anyway, that leads to the suggestion. An alternate view for the filtering pane - a simple list, sortable by the property name or the path to the property, and perhaps filterable in turn using a search phrase.

That way I could search for data source and find all properties with data or source in them, and thus see which ones I could/should filter out.


Back to top
View user's profile Send private message AIM Address
Dan J Archer

Joined: 10 Oct 2005
Posts: 81
Location: Red Gate Software

PostPosted: Mon Dec 12, 2005 3:40 pm    Post subject: Reply with quote

Hi Bernard,

You're quite right, at the moment you have to filter out Connection Properties as a whole or not at all.

This is because our filtering is based on typed objects, and whilst the Connection2 object containing the property "Connection Properties" is typed, Connection Properties itself is just a generic collection, and its contents are generic properties. The current filtering doesn't support such generic collections.

We had some rather nice plans to enhance the filtering for DTS Package Compare, to make it even more friendly and comprehensive. Given we're now rather close to release, I don't think these plans are going to make it into this version. But as and when future versions come out this area is definitely one I'd like to look at.

All the best,

Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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