Discussion:
[Liquibase-user] New Topic: How to rollback to a tag?
Liquibase Community Forum
2010-12-07 15:23:01 UTC
Permalink
A new topic, 'How to rollback to a tag?', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=818.new#new

The text of the topic is shown below:

Hi all. I have a question about rollback to a tag version.

I use Liquibase2.0-rc7 and I have these items into DATABASECHANGELOG table:

FILENAME| TAGscript1.xml| tag1 --> this script creates table 1 script2.xml| tag2 --> this script creates table 2 script3.xml| null --> this script creates table 3 script4.xml| null --> this script creates table 4
Now I want to rollback to tag1, so I use this command line:

Code:
java -jar ... --changeLogFile="script4.xml" rollbackSql tag1

which returns:

Code:
DROP TABLE4

but I 'd like to delete table2 and table3 also, because I'd like to get the same database schema
when It was tagged with tag1 label.

Do I have to call the same line command with --changeLogFile="script3.xml" and --changeLogFile="script2.xml" params?

I hope to get all rollback script (DROPT TABLE4, DROP TABLE3, DROP TABLE2) in one way. Is it possible?

Thx all 4 your help.

Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The Liquibase Community Forum Team.

Loading...