Generating diagrams from SQL schema

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
.

Relevant Pages

  • Re: Java is becoming the new Cobol
    ... In the Unisys 2200 environment using their Network Database Server, you get a schema work area depending on how you invoke the schema. ... However, it not only copies the schema area into the program, but the "DMCA" (Database Management Communication Area - basically, the block of information that holds your connection state) is copied in too. ... So, you're left with working-storage, which makes it visible to your program only, or common-storage, which makes it visible to programs linked in. ...
    (comp.lang.cobol)
  • Split messages
    ... This is based off the northwind database. ... Create document schema: ... Select the SQL entry, make sure that we are pointing to the SQL ... For the item select a receive pipeline and name it EmpSplitPipe.btp. ...
    (microsoft.public.biztalk.general)
  • Re: Decouple SQL queries from class in OOP design
    ... > Of course there are existing applications that uses many different ... > architectures and still provides measurable business value. ... > should access every database directly. ... by the database, but the schema changes. ...
    (comp.object)
  • ANN: Sequel 2.8.0 Released
    ... Sequel provides thread safety, connection pooling and a concise DSL ... for constructing database queries and table schemas. ... if you want to, but the results and API are adapter dependent, ... Model associations, getting the schema, joins, and many other ...
    (comp.lang.ruby)
  • Re: xsd files only: enough to start writing app. code of a DB-related component ?
    ... These schema definition files aren't very numerous (about 20 ... EIS database directly, and the database we were interested in was ISAM, and ... If they are good XSD files consider yourselves lucky. ... database schema from an XML schema. ...
    (comp.lang.java.programmer)