I recently review the DDLDatabase presentation here: https://www.jooq.org/doc/3.11/manual/code-generation/codegen-ddl/
This got me thinking about a problem that I wonder if jooq can address. We have to write our scripts in specific dialects of SQL. But, I want to write my scripts in jooq. This can already be done use the DDLQuery. But what if I have my script already and want to generate the jooq code that would need to be written from the script. That is, automatically generate the jooq code that represents the database. With this functionality, you would be able to make a connection to a database for any of the supported dialects and produce the java code equivalent in jooq that represents that database in DDL jooq queries. Once that is done, no more sql scripts! And, since the DDL is represented in jooq, the creation of the database under a new dialect is then trivial making migration from one database platform to another much easier. Anyway, I am just wondering if anyone else has thought of this use case. -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
