New Schema Design

26 Feb 2009 3:48 PM

Hulicat

Hello,
Not sure if this is the correct forum, however; I am looking for any
help or tool to assist in designing a new schema.

I have been tasked to a take an existed db with a bad design and
improve it on a SQL 2005 ent box.

I am not familiar with the old schema; I found a stored procedure to
spit out a table schema is there anything that will do that for a
whole db?

What is the best way to approach this?

I understand the basics of integrity, constrainsts, etc.

I would like to know how some of you would take this on.

Thanks,

26 Feb 2009 5:06 PM

Mohit K. Gupta

Hi,

You can use 3rd party tools to do Schema Design, that let you do all the
details and then generate the schema on the database. You can also use
Microsoft Viso Database Edition to do the similar thing.

In addition in SQL Server Database Diagram function to generate a new
schema and plot out the old schema.

Hope that helps :).

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Show quoteHide quote

"Hulicat" wrote:

> Hello,
> Not sure if this is the correct forum, however; I am looking for any
> help or tool to assist in designing a new schema.
>
> I have been tasked to a take an existed db with a bad design and
> improve it on a SQL 2005 ent box.
>
> I am not familiar with the old schema; I found a stored procedure to
> spit out a table schema is there anything that will do that for a
> whole db?
>
> What is the best way to approach this?
>
> I understand the basics of integrity, constrainsts, etc.
>
> I would like to know how some of you would take this on.
>
> Thanks,
>

28 Feb 2009 3:02 PM

Hulicat

Thanks Erland and Mohit that was the feedback I was looking exactly.

26 Feb 2009 11:23 PM

Erland Sommarskog

Hulicat (dennis_A_wh***@yahoo.com) writes:
Show quoteHide quote

> Not sure if this is the correct forum, however; I am looking for any
> help or tool to assist in designing a new schema.
>
> I have been tasked to a take an existed db with a bad design and
> improve it on a SQL 2005 ent box.
>
> I am not familiar with the old schema; I found a stored procedure to
> spit out a table schema is there anything that will do that for a
> whole db?
>
> What is the best way to approach this?
>
> I understand the basics of integrity, constrainsts, etc.
>
> I would like to know how some of you would take this on.

I would prefer to use a real data-modelling tool like PowerDesigner
or ErWin, but that is because I'm used it. (More exactly to PowerDesigner.)
But there is an apparent problem with these products: the price tag.

You can create database diagrams in Mgmt Studio, but those are too
thin for my taste.

Red Gate's SQL Doc may be a better option. It's not a full-fledged
modelling tool, but it's a lot chaper.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx