Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2007-05-07 : 10:59:56
|
| Hello Guys, I was asked to develop something that would do some basic data modeling in one of our brand new databases, what I'm looking to get out of this sp would be number of fields, number of records, min val, max val logged to an output table, they also asked me to go thru each column, group by and log the values to an output table as well.First, I was wondering if anyone has been involved into such a thing and could help me with something to begin with, secondly I'm asking myself if SQL 2005 doesn't already has any tool that would do this for me, Analysis Server maybe?Thanks in advance for the help.---"Try not to become a man of success but rather try to become a man of value." |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-05-08 : 05:13:49
|
| What you're describing is data profiling rather than data modeling. I don't think Microsoft have anything that specifically addresses this. Have a look at this link for an approach using SSIS:[url]http://msdn2.microsoft.com/en-us/library/aa964137.aspx[/url]Otherwise you're looking at a dedicated data profiling tool such as Trillium Data Discovery: [url]http://www.trilliumsoftware.com/home/products/data-profiling/data-discovery.aspx[/url]. There's plenty of these on the market (try googling "Data Profiling"), but they tend to be fairly pricey.Mark |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-05-09 : 13:22:42
|
| You're correct, data profiling is what I need. That's a pretty interesting link you sent, thanks a lot.I'll look for tools available on the market.Thanks for your reply.---"Try not to become a man of success but rather try to become a man of value." |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-05-10 : 03:31:19
|
| No problem - good luck!Mark |
|
|
|
|
|
|
|
|
Analysis & Data Modeling