Schema diff

Use jOOQ's schema diff tool to calculate the diff going from one schema version to another.

This is work in progress. Your help in improving our parser is greatly appreciated. See below how to report bugs.

-- Old schema version (in SQL)

 
Input Dialect
Search path, comma separated
Parse unknown functions
Formats
Date Format
Timestamp Format
Comments
Retain comments between queries
Enable ignore comment syntax
Ignore comment start token
Ignore comment stop token
-- New schema version (in SQL)

 
Output Dialect
Keywords
Identifier Case
Identifier Quoting
Bind variables

Output:


                
        
 

*How does it work?

The input dialect is a mixture of all of jOOQ's currently supported SQL dialects. The grammar can be found here. This works the same way as our translate tool.

We're interpreting both versions of your schema and then producing a set of SQL statements that would lead from one version to the other.

If you've found an error, or would like to suggest an improvement, please report it here, along with your input query: https://github.com/jOOQ/jOOQ/issues/new.

Cool, can I embed this in my application!?

Yes! And you don't even need to use the jOOQ API. The diff tool can be exposed through the JDBC API.

We haven't published it yet. It will be part of jOOQ 3.13.

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo