Is there a way to convert SQL queries to liquibase changelog format?

java sql spring-data-jpa liquibase liquibase-hibernate
Belham picture Belham · Nov 12, 2018 · Viewed 8.8k times · Source

I would like to know if it is possible to convert an existing SQL script into XML format of changelogs of a liquibase?

Answer

Jens picture Jens · Nov 13, 2018

You could use a detour via a database. Apply your script to a database of choice (that is supported by liquibase). Then use generateChangeLog to generate the changelogs in xml from the database.

Related questions

How to convert java.util.Date to java.sql.Date?

I am trying to use a java.util.Date as input and then creating a query with it - so I need a java.sql.Date. I was surprised to find that it couldn't do the conversion implicitly or explicitly …

Read More
could not extract ResultSet in hibernate

I have a problem with Hibernate. I try to parse to List but It throws an exception: HTTP Status 500 - could not extract ResultSet. When I debug, It fault at line query.list()... My sample code here @Entity @Table(name = "…

Read More
Hibernate show real SQL

if I set <property name="show_sql">true</property> in my hibernate.cfg.xml configuration file in the console I can see the SQL. But it's not real SQL... Can I see the SQL code that …

Read More