Hi, I’m testing out liquibase for our dbs. we already have an existing dbs. I want to add our entire db into liquibase xml change log. I understand Liquibase would just work in existing db but I will only have change sets from that point. if I want to create a new db using changelog, I wont be able…

Thanks Dary. I’m testing liquibase with Postgresql database. May i know what are the objects that might not get extracted in postgresql.

Hi @Ashad I’m not 100% sure but what I know is if you are using Liquibase Pro, most of the objects (almost all) would get covered with generateChangelog. However, if you using Liquibase Open Source then generateChangelog will not extract : function stored procedure trigger for your PostgreSQL da…

Thanks, Rakhi, I’m currently using Liquibase Open Source for testing purposes.

Hi @rakhi , Thanks for your input. Could you please give me some advice what is the right way to use liquibase in my environment. I have a db in postgres and ms sql and there are couple of schemas in db. now when there is a change db, i write sql statement for both db and run them manually in each d…

Hi @Ashad Happy to know you are planning to use Liquibase in your project. [image] Ashad: Is this a good idea ? Using XML changelogs and changesets is a good idea. It has a lot of features which allows us to use different functions for DBs. Please follow this link for Liquibase best practic…

Thanks again @rakhi . Your answer is really useful. I have another issue in using liquibase xml format. There is no proper documentation on how Liquibase handle datatypes for different database types. I use mssql and postgres. I looked up to a table in a third party site on liquibase equivalent da…

You can use changelog parameters to control the datatypes used by a dbms. Here is a snippet from changelog parameters . <property name="clob.type" value="clob" dbms="oracle,postgresql"/> <property name="clob.type" value="longtext" dbms="mysql"/> <property name="table.name" value="tableA…

Convert DB to Liquibase xml

General Discussion

daryldoak April 6, 2021, 2:55pm 2

You can use the generateChangeLog command to capture the current state of the database into changelog format. Be aware that not all objects types are extracted.

https://docs.liquibase.com/commands/community/generatechangelog.html

Topic		Replies	Views
Translator from MySQL to liquibase General Discussion	9	4255	August 5, 2015
Creating a database changelog xml file from an existing database? General Discussion	5	1000	April 6, 2011
Working multiple database with Liquibase General Discussion	1	369	August 1, 2025
Generatechanglog for both Postgres and Oracle? General Discussion	5	1513	August 9, 2023
Generate XML/ SQL output with data types of target database General Discussion	1	1100	August 27, 2014

Free Tools

Cheat Sheets

eBooks

Comparison Guides

Convert DB to Liquibase xml

Free Tools

Cheat Sheets

eBooks

Comparison Guides

Convert DB to Liquibase xml

Related topics