Liquibase Community Forum
2010-12-07 15:23:01 UTC
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.
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.