Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

SQL Server Metadata Toolkit 2008

with 2 comments

One of the few sessions I was able to see last week at the PASS European Conference (I had to leave very early, unfortunately) was Markus Raatz’s excellent “New Treasures for Microsoft BI Found on Codeplex”. Among other things, he showed off a new project on Codeplex that I hadn’t seen before: SQL Server Metadata Toolkit 2008. It’s an updated version of the SQL Server Metadata Toolkit that was released for 2005 a few years ago, and allows you to trace metadata dependencies between the relational database, SSIS packages and SSAS objects. So if, for example, you change a column name in a dimension table you should be able to work out which SSIS packages and which SSAS dimensions will be broken. You can download it here:
http://sqlmetadata.codeplex.com/

I’ve not had a chance to download it yet, but it looks like it will be very useful.

Written by Chris Webb

April 26, 2010 at 9:24 pm

Posted in Analysis Services

2 Responses

Subscribe to comments with RSS.

  1. I\’m wondering what differences this has from 2005 version. I actually just took the 2005 version and modified it to work with 2008. It was package id (guids) and the like that had to change, and references in the code to the 2008 assemblies.I\’m looking forward to playing with this.

    Steve

    April 26, 2010 at 9:49 pm

  2. The major addition (as far as I can see) is a sql parser to extract the tablenames from SQL queries. Which is extremely useful I think.

    Frenk

    April 27, 2010 at 3:38 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,309 other followers

%d bloggers like this: