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!
