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?



Monday, March 3, 2003

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

Tuesday, March 4, 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 4, 2003

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


Tuesday, March 4, 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!

Colin Evans
Tuesday, March 4, 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 5, 2003

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

Wednesday, March 5, 2003

Eugene - what does ER/Win do that's worth $8k?
Recently I've been using Dezign for Databases ( ) 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.


Philip Janus
Wednesday, March 5, 2003

*  Recent Topics

*  Fog Creek Home