Thursday, 15 July 2004

Generate schema

Something that I didn't know "back in the day", but MS Visio can "reverse engineer" your db structure. You just have to set up a ODBC datasource, point to it (using the correct driver of course) and it will generate a schema for you. Mind you, it might not be the prettiest looking one, but it's a up to date schema without having an expensive tool to do it for you. I love tools that generate documentation...
Listening to: Pearl Jam - Given to Fly


Posted by at
Labels:

1 comment:

  1. Jim15 July 2004 at 14:24

    Steps:
    1) Open up a database model drawing (ER)
    2) Database -> reverse engineer
    3) use the wizard to connect to your ODBC datasource that you set up
    And it's done. If you have any troubles, make sure you set up the ds correctly by testing it.

    ReplyDelete

Subscribe to: Post Comments (Atom)