Re: One design for different DBMSs

From: Matti Teppo <matti.teppo_at_nospam.deio.net>
Date: Wed, 15 Aug 2001 11:57:19 +0200
Message-ID: <3B7A477E.FD8B47FE@nospam.deio.net>

> If you use a tool such as Embarcadero Technologies ER/Studio, then
> it's a no brainer. It allows you to develop logical models in
> either Sybase, Oracle, MSSQLServer and DB2, then deploy them automatically
> in any of the others. Highly recommended.

>PD: It's a decent tool, but I can say I would look at Erwin 4, and compare the
>SQL Server support if I were purchasing again. We eval'd ERStudio, but at
>that time it did not support SQL 2000.

Rational's Data Modeler does the same, but seems to be still somewhat buggy. Some database design operations (eg duplicating a table or merging schemas) are not directly supported, but you must do it through forward and backward engineering.

Matti Received on Wed Aug 15 2001 - 04:57:19 CDT