Hello,

I am looking for a tool that builds ERDs and Database diagrams and
from these generate the database scripts to create the schema. This is
the main thing I am looking for; building the database, generating
create script from the diagram.
1. Does Microsoft have such a tool?
2. Does VisioStudio allow one to generate the SQL Scripts from the
database diagram?
3. Is there a recommended Freeware Version?
4. Is there a recommendation for a tool?

Thanks Very Much.

DevDewboy

Left out one other mention: It should not be limited to generating
database create scripts to just SQL Server. Generating Oracle scripts
is a good.

There are several of them, I guess depends on the users/developers preference
in term of which one to use.

Some of the ones that I know about:
-. SQL Server - SQL Server come with Diagram tool, where you can design ER
Diagram, and then you can generate scripts, and changes that you make to ER
diagram can go directly to the database.
-. Visio - A great tool, you can do ER-diagram there, then connect to
database and push your changes to database. The reverse also true, you can
connect to SQL Server and then have Visio to create the ER diagram of your
existing database. I have not try Visio with Oracle so not sure if that going
to work.
-. Altova DatabaseSpy - A thirdparty software, not free, but it should work
with SQL Server and Oracle.

"devdewboy" wrote:

I've been really happy with Toad Data Modeler. It's got a lot of features,
but is very reasonable in price.

"devdewboy" wrote: