Home All Groups Group Topic Archive Search About

Tool to review SQL schema design

Author
3 Jan 2007 12:44 PM
Baskar
Hi

I have created a database with all PK & FK relationship defined for my
project. I wanted to make sure that my schema/table design is perfect. Any
tool available to review my schema/table design? If yes, kindly send me the
details.

Regards,
Baskar C.G

Author
3 Jan 2007 12:53 PM
Hari Prasad
Hello,

Create a database Diagram for the database using enterprise manager -- 
diagrams. You can also use tools like"-

1. ERWIN
2. MS Visio

Thanks
Hari



Show quote
"Baskar" <Bas***@discussions.microsoft.com> wrote in message
news:2BD915C4-F8E5-4110-B33A-04E9C5712C01@microsoft.com...
> Hi
>
> I have created a database with all PK & FK relationship defined for my
> project. I wanted to make sure that my schema/table design is perfect. Any
> tool available to review my schema/table design? If yes, kindly send me
> the
> details.
>
> Regards,
> Baskar C.G
>
Author
3 Jan 2007 5:30 PM
Aaron Bertrand [SQL Server MVP]
What makes a schema "perfect"?  There are tools out there that will let you
analyze your schema in different ways, and even some that will point out bad
techniques (e.g. best practices analyzer).  But no product is going to give
your schema a score, never mind rate it as "perfect."  Perfecting your
schema is your job and is not the part that should be automated (even if it
were possible).





Show quote
"Baskar" <Bas***@discussions.microsoft.com> wrote in message
news:2BD915C4-F8E5-4110-B33A-04E9C5712C01@microsoft.com...
> Hi
>
> I have created a database with all PK & FK relationship defined for my
> project. I wanted to make sure that my schema/table design is perfect. Any
> tool available to review my schema/table design? If yes, kindly send me
> the
> details.
>
> Regards,
> Baskar C.G
>

AddThis Social Bookmark Button