A way to translate sql scripts to a different dialect

#sql #sqlserver #hsqldb #jooq

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)

AI Training Breakthrough: New Method Cuts Learning Time by 30% While Boosting Performance

Mike Young - Mar 1

AI Breakthrough: New Method Helps Language Models Better Understand Tables Using Hybrid Learning

Mike Young - Mar 1

Breakthrough AI Model Can See and Speak in 22 Indian Languages, Making Technology More Accessible to Billions

Mike Young - Mar 1

Specialized Neurons in Language AI Act as Relationship Experts, Scientists Find

Mike Young - Mar 1

Try REST API Generation for MS SQL Server.

DreamFactory generates live REST APIs from database schemas with standardized endpoints for tables, views, and procedures in OpenAPI format. We support on-prem deployment with firewall security and include RBAC for secure, granular security controls.

See more!

DEV Community

A way to translate sql scripts to a different dialect

Top comments (0)

Try REST API Generation for MS SQL Server.

Read next

AI Training Breakthrough: New Method Cuts Learning Time by 30% While Boosting Performance

AI Breakthrough: New Method Helps Language Models Better Understand Tables Using Hybrid Learning

Breakthrough AI Model Can See and Speak in 22 Indian Languages, Making Technology More Accessible to Billions

Specialized Neurons in Language AI Act as Relationship Experts, Scientists Find

Okay