CODEWITHSUNDEEP
sqlms-accessodbc
himself
himself

Reputation: 4884

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

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...

Upvotes: 2

Views: 2762

Answers (3)

renick
renick

Reputation: 3881

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

Upvotes: 1

himself
himself

Reputation: 4884

Okay, I wrote the tool to export access schema/parse SQL files myself, it's available here:

https://bitbucket.org/himselfv/jet-tool

Feel free to use if anyone needs it.

Upvotes: 3

Codek
Codek

Reputation: 5164

Adding this because I wanted to search an ODBC schema, and came across this post. This tool lets you dump a csv format of the schema itself:

http://sagedataobjects.blogspot.co.uk/2008/05/exploring-sage-data-schema.html

And then you can grep away..

Upvotes: 2

Related Questions