I want to ask that is it possible to design databases using SQL Server ? Is there any external tool required to use with SQL Server or can be done in itself ?
-
5You can design a database with paper and a pencil ... no high-tech tools needed, really.marc_s– marc_s2012-08-10 16:20:39 +00:00Commented Aug 10, 2012 at 16:20
-
@marc_s While working in a professional corporate environment, they don't wanna see the work on a paper with a pencil. So, any suggestion according to that would be appreciated.shah khan– shah khan2012-08-10 16:25:29 +00:00Commented Aug 10, 2012 at 16:25
-
Well, SQL Server does have some very limited tools - like the database diagrams and table designer. But that's by no means a real, professional-grade database design tool. So if you can't live with pencil and paper, I would think the very limited tools built into SQL Server are probably not good enough for your corporate environment, either.marc_s– marc_s2012-08-10 16:35:33 +00:00Commented Aug 10, 2012 at 16:35
-
If you need a full-blown, professional enterprise grade database design tool - like at products like CA ERWin or Sybase PowerDesigner. Those are pretty $$$$$$ though....marc_s– marc_s2012-08-10 16:40:13 +00:00Commented Aug 10, 2012 at 16:40
-
Visio always works nice for ERDsLimey– Limey2012-08-10 17:38:02 +00:00Commented Aug 10, 2012 at 17:38
|
Show 1 more comment
3 Answers
Unless I am completely not understanding what you are asking. You can use SQL Server Management Studio to design databases.
Comments
You need a tool like DBDesigner. Check it out > http://www.fabforce.net/dbdesigner4/screenshots.php
Comments
I would put more emphasis on the long term implications of database design, having to maintain the design over time. I would look for a tool that can compare the schema that should be on the live system, with the schema that is really on the live system (as a rule, in a corporate environment, they are never the same). Maybe something like Altova DatabaseSpy.
Comments
