Which tool to use to export SQL schema from ODBC database?

Question

I have a database in a format which can be accessed via ODBC. I'm looking for a command-line tool to generate SQL file with DROP/CREATE statements from it, preferably with all the information including table/field comments and table relations. (Possibly for a tool to parse the file and import the schema too, but I guess this would be relatively easier to find). Need this to automate workflow, to be able to design the database visually but store it in SVN in code form.

Which tool should I use?

If this helps, the database in question is MS Access, but I guess there's a higher chance of finding a generic ODBC tool...

Answer 1

This script may work for you with some modifications. Access (the application) is required though.

Answer 2

Okay, I wrote the tool to export access schema/parse SQL files myself, it's available here: http://code.google.com/p/jet-tool/. Feel free to use if anyone needs it.