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 also needs liquibase_common.xslt.
• Extract procedures
• Generate Confluence Wiki code

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 also needs liquibase_common.xslt.
• 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

• Transform an XML export into a Liquibase INSERT changeset   (See Liquibase Insert Data)
• Transform an XML export into a CSV file
• Transform an XML export int a DbUnit XML file
• Transform an XML export into a DbUnit flat XML file

The scripts can also be downloaded from the Git repository.