Hello,

I'm looking for a tool which allows me to visually/graphically design a database. (I'm thinking of something which looks like the class designer in Whidbey.)

It should allow me to design tables, columns with their data-types, and PK/FK constraints and then should - automagically on button click - create/update the DB-Schema for me (or create scripts, if not connected).

I want to use this as an Add-on to be able to import the schema into LlblGenPro.

The tool should be DB-independent, so I can create SQL-Server, Access, Oracle, MySql etc. schemas from the same design. I currently don't have a need to design Views and/or Sprocs.

Any recommendations?

Thanks, Robert

Visually designing a db could be done using Visio, (or vs.net enterprise architect). Another tool is ER/win. Some people really hate it, others love it.

Otis wrote:

Visually designing a db could be done using Visio, (or vs.net enterprise architect). Another tool is ER/win. Some people really hate it, others love it.

Hi Frans,

I can design DB diagrams in Visio, but I couldn't find out how to generate/update the DB or how to create scripts from it.

In VS.NET EA - where do I find it? Seems I'm blind

Regards, Robert

I've been digging on this one for awhile now.

DeZign for Databases http://www.datanamic.com/dezign/index.html

The price isn't too bad either.

cmartinbot wrote:

I've been digging on this one for awhile now.

DeZign for Databases http://www.datanamic.com/dezign/index.html

The price isn't too bad either.

thanks, will have a look...

Robert

Otis wrote:

Visually designing a db could be done using Visio, (or vs.net enterprise architect). Another tool is ER/win. Some people really hate it, others love it.

I hate ER/win because of the prize: $ 4.000,- !

SCNR, Robert

bobfox wrote:

Otis wrote:

Visually designing a db could be done using Visio, (or vs.net enterprise architect). Another tool is ER/win. Some people really hate it, others love it.

Hi Frans,

I can design DB diagrams in Visio, but I couldn't find out how to generate/update the DB or how to create scripts from it.

In VS.NET EA - where do I find it? Seems I'm blind Regards, Robert

VS.NET EA, comes with a visio version which supports ORM (Object Role Modelling, http://www.orm.net) and E/R model. I always create a database project in it, like datablase model diagram, ER source model, ORM Diagram etc. You can then generate your project, create update scripts and create for example an E/R model diagram.

It can be somewhat cumbersome with large models though.

I will add Enterprise Architect to the list.

erwin is expensive, but man, creating oracle schema, sql server schema, and db2 schema from the same logical model rocks.

plus the reporting features are phenominal and its way more stable than visio EA.