Track Database changes made with out using changeset

General Discussion
1

I think we can use the futureRollbackSQL mode to get what I want.

 

2

You could use the liquibase diff and diffchangeset commands to see what the changes are, or to generate a changeset that has the changes necessary to get the databases back in sync. 

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/

3

In order to do the comparison, yes, you will need two databases. Most development shops have more than one copy of their database, but if you don’t then all you need to do is create a new empty database and use liquibase to create the schema using the changelogs you have. Then compare that with the one that has the changes made without liquibase to see what the differences are. If you use the diff command, Liquibase will show you a ‘human readable’ version of the differences. If you use the diffChangelog command, then the changelog will be altered to have the correct change sets to bring the two databases into sync. 

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/

4

Hi All,

How to keep track of changes made to a database that are done with out using the changesets. This is the scenario.

Made Changes to database using changesets for release 1.

Made another set of changes to database using changesets for release 2.

But when it came to release 3 changes were made to database directly with out using changesets. 

Now i want to track those changes so that i can roll back those changes using liquibase up to release 2. I.e i want to roll back all changes that have taken place after release 2.

What options do i have? 

5

Thank you Steve, do i have to use both Diff and diffchangeset or just one of these. Most of the diff examples given were for comparing two database.  but in my case its diff within  a single database

Would you please provide an example of how to use these two to get the difference.