Fog Creek Software
Discussion Board




Database modeling in Visio 2002

Visio 2000 could create DDL scripts from an ER diagram. Visio 2002 does not seem to be able to do this. Does anyone know why Visio 2002 dropped this feature?

Does anyone have any other gripes about using Visio for db modeling?

TIA,

Jeff

Jeff
Monday, March 03, 2003

It amy be that visio/M$ wants to adopt the UML profile for datamodelling and genrate DDL from there?

Karel
Tuesday, March 04, 2003

I also noticed that MS dropped support for Sybase SQL Server in Visio 2002 which Visio 2000 supported very well.

Sanjay Sheth
Tuesday, March 04, 2003

Generating DDLs is still possible but only with the Visio Entreprise version that comes with Visual Studio .Net!

Greets,

Fred
Tuesday, March 04, 2003

I use CASE Studio to do my ER modeling; Visio's ER support is crappy.  At $330 for a license, it is a deal!

http://www.casestudio.com/enu/

Colin Evans
Tuesday, March 04, 2003

Being a DBA - database modeling is part of my job. My preference always has being ERWin. It is not cheap, but probably best suited for all modeling-related, DML generation, reverse-engineering of the existing DB, etc., tasks. I hope CA does not ruin the great software :-(

Eugene Patek
Wednesday, March 05, 2003

If CA's past performance is any indication, I don't think you have much hope.

RocketJeff
Wednesday, March 05, 2003

Eugene - what does ER/Win do that's worth $8k?
Recently I've been using Dezign for Databases ( www.datanamic.com ) for ER Design. It can reverse engineer, it's easy to work in, it displays exactly what I need, it can generate the DDL scripts, and it's $100.

I looked at Case Studio (posted above) last night, and it looks even better, and is $300.

Philo

Philip Janus
Wednesday, March 05, 2003

*  Recent Topics

*  Fog Creek Home