使用哪个工具从 ODBC 数据库导出 SQL 架构?
我有一个可以通过 ODBC 访问的格式的数据库。我正在寻找一个命令行工具来生成带有 DROP/CREATE 语句的 SQL 文件,最好包含所有信息,包括表/字段注释和表关系。 (可能是一个解析文件并导入模式的工具,但我想这会相对更容易找到)。需要它来自动化工作流程,以便能够直观地设计数据库,但以代码形式将其存储在 SVN 中。
我应该使用哪个工具?
如果这有帮助,那么有问题的数据库是 MS Access,但我想找到通用 ODBC 工具的机会更大......
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...
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
好的,我自己编写了导出访问模式/解析 SQL 文件的工具,可以在这里使用:
https:// bitbucket.org/himselfv/jet-tool
如果有人需要,请随意使用。
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.
添加此内容是因为我想搜索 ODBC 架构,并遇到了这篇文章。该工具可让您转储模式本身的 csv 格式:
http://sagedataobjects.blogspot.co.uk/2008/05/exploring-sage-data-schema.html
然后你就可以 grep 走了..
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..
此脚本可能有效为您进行一些修改。但需要访问(应用程序)。
This script may work for you with some modifications. Access (the application) is required though.