DEV Community

taijidude
taijidude

Posted on

1

A way to translate sql scripts to a different dialect

One application i'm responsible is running on a sql server database but most of the integration tests are running against a hsql in memory database. For a bigger integration test i had the need to convert some sql scripts. While researching i found this wonderful tool. Im not affiliated with them in any way. I'm writing this more as a note to myself. I want to investigate it more.

The left textfield is for your input sql and the right textfield is for your translated output.

Enjoy:

https://www.jooq.org/translate/

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more