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?
It amy be that visio/M$ wants to adopt the UML profile for datamodelling and genrate DDL from there?
I also noticed that MS dropped support for Sybase SQL Server in Visio 2002 which Visio 2000 supported very well.
Generating DDLs is still possible but only with the Visio Entreprise version that comes with Visual Studio .Net!
I use CASE Studio to do my ER modeling; Visio's ER support is crappy. At $330 for a license, it is a deal!
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 :-(
If CA's past performance is any indication, I don't think you have much hope.
Eugene - what does ER/Win do that's worth $8k?
Fog Creek Home