Several SQL Workbench/J commands produce XML output (e.g. WbSchemaReport or WbSchemaDiff).
On this page you can find some sample XSLT files to transform these output formats into SQL scripts or HTML documents.
They are far from beeing production-quality scripts and are meant as a starting point for your own needs.
If you have developed an XSLT file to support the various XML outputs of SQL Workbench/J and would like to share it, please send it to support@sql-workbench.eu
WbSchemaReport transformations
The following files will transform the output of the WbSchemaReport command
- HTML output
- Create a script for PostgreSQL
- Create a script for Oracle
- Generate a Liquibase Changeset
The script includes liquibase_common.xslt. Both files are needed - Extract procedures
- Generate Confluence Wiki code
- Generate an initial stub for a Benerator
script
WbSchemaDiff transformations
The following files will transform the output of the WbSchemaDiff command
- Transform to a PostgreSQL script
- Transform to an Oracle script
- Transform to a Liquibase changeset
The script includes liquibase_common.xslt. Both files are needed - Transform to an Apache Derby script
- Transform to an Microsoft SQL Server script
WbExport transformations
The following files will transform the XML output of the WbExport command