I'm looking to automatically generate an XML version of a database schema from SQL (Postgres) DDL.
我希望从SQL(Postgres)DDL自动生成XML版本的数据库模式。
Are there any tools to help with getting from the DDL to XML?
是否有任何工具可以帮助您从DDL到XML?
xml2ddl claims to do this, but it fails to connect and seems unsupported since 2005.
xml2ddl声称这样做,但它自2005年以来无法连接并且似乎不受支持。
3 个解决方案
#1
2
You can use the built-in table_to_xmlschema etc.; see http://www.postgresql.org/docs/current/static/functions-xml.html#FUNCTIONS-XML-MAPPING.
您可以使用内置的table_to_xmlschema等;请参阅http://www.postgresql.org/docs/current/static/functions-xml.html#FUNCTIONS-XML-MAPPING。
#2
1
Things that spring immediately to my mind:
我心中立刻想到的事情:
Liquibase
Schemaspy
SQL Workbench's WbSchemaReport
Liquibase Schemaspy SQL Workbench的WbSchemaReport
They don't use a DDL (SQL) script as input but require a database connection.
它们不使用DDL(SQL)脚本作为输入,但需要数据库连接。
#1
2
You can use the built-in table_to_xmlschema etc.; see http://www.postgresql.org/docs/current/static/functions-xml.html#FUNCTIONS-XML-MAPPING.
您可以使用内置的table_to_xmlschema等;请参阅http://www.postgresql.org/docs/current/static/functions-xml.html#FUNCTIONS-XML-MAPPING。
#2
1
Things that spring immediately to my mind:
我心中立刻想到的事情:
Liquibase
Schemaspy
SQL Workbench's WbSchemaReport
Liquibase Schemaspy SQL Workbench的WbSchemaReport
They don't use a DDL (SQL) script as input but require a database connection.
它们不使用DDL(SQL)脚本作为输入,但需要数据库连接。