1

How is it possible to use liquibase for comparing "original" database and "updated" one to generate the changeset from the differences (postgresql)?

I checked documentation and realized that there is no such feature listed. So perhaps I need to look at other tools?

Mark O'Connor
  • 76,015
  • 10
  • 139
  • 185
jdevelop
  • 12,176
  • 10
  • 56
  • 112
  • See: http://stackoverflow.com/questions/8397488/comparing-databases-and-genrating-sql-script-using-liquibase/8408334#8408334 – Mark O'Connor Dec 16 '12 at 20:47
  • How about relying on your source control system for a diff. Using a branch or a tag should allow you to see this. – Kuberchaun Dec 17 '12 at 01:17

1 Answers1

0

I didn't find any tool for this that outputs at least relatively good diff. There were some tools that were producing differences files, but the output was unacceptable.

You may want to read this post from liquibase blog. The Problem With Database Diffs

rchukh
  • 2,877
  • 2
  • 21
  • 25
  • Liquibase can also generate diffs between databases. It's a useful feature in order to capture changesets that might have occured without liquibase's knowledge – Mark O'Connor Dec 16 '12 at 20:51
  • @MarkO'Connor This output sure can be used as a base. But it won't save you from possible problems (see link above for example of those). – rchukh Dec 17 '12 at 09:49
  • I don't deny the issues with diffs. See the links I have in this answer: http://stackoverflow.com/questions/12746908/how-to-automate-deployment-of-changes-to-database/12752861#12752861 – Mark O'Connor Dec 17 '12 at 12:06