Creating a database changelog xml file from an existing database (including stored procs) using Liquibase

Question

Is it possible to create an initial database changelog xml file from the existing state of the database?

I believe I've generated the schema using generateChangeLog, but it doesn't seem to return the stored procedures (or the data).

I'm using SQL Sever 2008

Rafael M · Accepted Answer · 2015-01-29 23:07:58Z

3

You can return the data using a diffTypes flag that includes "DATA". See http://www.liquibase.org/documentation/diff.html.

Liquibase cannot currently output stored procedures, however. For that you will need to use a different tool and include them in the generated changelog using the tag.

edited Jan 29, 2015 at 23:07

Rafael M

3934 silver badges12 bronze badges

answered Apr 7, 2011 at 19:05

Nathan Voxland

15.9k2 gold badges51 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Victor Zanella Over a year ago

Is there a tool to generate the changelog of procedures, functions and trigger ?

Noyal · Accepted Answer · 2017-10-11 10:08:33Z

2

download liquibase.jar , database driver and save to one directory (Ex:/home/mySystem/liquibase), in the command line change the directory to (/home/mySystem/liquibase) and run the below mentioned command

java -jar liquibase.jar --driver=org.postgresql.Driver --classpath=postgresql-42.1.3.jar --changeLogFile=db.changelog.xml --url="jdbc:postgresql://localhost:5432/<databasename>" --username=<username> --password=<password> update

Reference link:

http://www.liquibase.org/documentation/generating_changelogs.html

answered Oct 11, 2017 at 10:08

Noyal

2531 gold badge3 silver badges7 bronze badges

Comments

Nightscape · Accepted Answer · 2011-06-29 12:57:42Z

0

I just yesterday discovered SQL Power Architect, which seems to be able to generate Liquibase configurations: http://www.sqlpower.ca/page/architect

For more info on this combination see this blog post: http://blog.mgm-tp.com/2010/11/data-modeling-part2/

answered Jun 29, 2011 at 12:57

Nightscape

4945 silver badges13 bronze badges

1 Comment

Ellis Over a year ago

Seems like sql power architect suffers from the same limitations when it comes to exporting procedures etc. "However, be aware that if you intend to copy more sophisticated concepts like check constraints, non-standard indices (e.g. Oracle’s Bitmap indexes), triggers, views or stored procedures as well, that Power Architect is not yet able to reverse engineer them automatically. You have to extract this information manually from your existing database and enter the concepts as special “Custom SQL” statements to LiquiBase separately."

Collectives™ on Stack Overflow

Creating a database changelog xml file from an existing database (including stored procs) using Liquibase

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related