Re: Recommendations for SQL Server-compatible database design tool?

Oenone (oenone@xxxxxxxxxxx) writes:
Can anyone recommend a utility (preferably free but can pay if needed)
that will allow me to easily design database structures (tables,
indexes, relationships) for SQL Server?

I have a couple of specific requirements for it:

- must be able to store its designs in an accessible format (e.g., XML) so
that I can write code to parse and modify its files.

- must be able to allow me to specify whether an index should be clustered
or not.

The tool we use fulfil these requirements, PowerDesigner from Sybase. But
it's certainly not free. PD as a whole range of design modules, and you
would probably only use physical design (it's the only module we have).
Nevertheless, I believe the price is over 1000 USD.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Problem when changing Views
    ... There aree several reasons. ... I use neither of the tools, but I guess that Design View resubmits the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: How to handle concurrency issue with better performance?
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Then for timestamp, it will be unique? ... Collisions occur because your design permits ... select command). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Design
    ... The design you aim at is known as EAV, ... Mob = MIN, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: ORDER BY in VIEW not working
    ... As an object-oriented programmer, I expect to be able to encapsulate ... The relevant design principle is that of Orthogonal Design. ... State what version of SQL Server you are using and specify the content ...
    (comp.databases.ms-sqlserver)
  • Re: Target number of database reads per user
    ... Yeah, just to echo what Andy is saying, if you want to have the question ... If you can post code/database design we could all take a look. ... Pro SQL Server 2000 Database Design - ...
    (microsoft.public.sqlserver.programming)