Generating diagrams from SQL schema

[passion_to_be_free]

I am trying to create a data model for a database that I actually
don't have access to. However, I do have the schema. (I assume this is
what would be considered "schema" - it's a .sql file that has all of
the create statements to create the tables, views, and triggers)

I figure there must be a way to feed this into visio and have it spit
out a data model. I'm sure it won't be perfect, but it would be a
great start. I've looked at the "Reverse Engineer" option, but it
seems to me that it is trying to connect to a database to extract the
schema before it creates the new diagram.

As I said, I don't have access to the db, but I already have the
schema. Is there a way for me to skip the extraction step and just
poin to the SQL file that contains the shema?

I'm using Visio Professional 2003 SP1

 

[Al Edlund]

visio uses an odbc interface to gather the necessary information on the
reverse-engineering, AFAIK it doesn't read sql direct. If you have the
creation list, why not create the database (with no data in it) and the
attempt the reverse-engineering.
al