{"id":69154,"date":"2020-09-06T16:54:04","date_gmt":"2020-09-06T16:54:04","guid":{"rendered":"https:\/\/www.baeldung.com\/?p=86708"},"modified":"2020-09-06T16:54:04","modified_gmt":"2020-09-06T16:54:04","slug":"rolling-back-migrations-with-flyway","status":"publish","type":"post","link":"https:\/\/itteacheritfreelance.hk\/wordpress\/index.php\/2020\/09\/06\/rolling-back-migrations-with-flyway\/","title":{"rendered":"Rolling Back Migrations with Flyway"},"content":{"rendered":"

<\/p>\n

1. Introduction<\/h2>\n
<\/div>\n

In this short tutorial, we’ll explore a couple of ways to rollback a migration with\u00a0Flyway.<\/a><\/p>\n

2. Simulate Rollback with a Migration<\/h2>\n
<\/div>\n

In this section, we’ll rollback our database using a standard migration file.<\/p>\n

In our examples, we’ll use the command-line version of Flyway. However, the core principles are equally applicable to the other formats, such as the core API, Maven plugin, etc.<\/p>\n

2.1. Create Migration<\/h3>\n
<\/div>\n

First, let’s add a new book<\/em> table to our database.\u00a0In order to do this, we’ll create a migration file called\u00a0V1_0__create_book_table.sql<\/em>:<\/p>\n

create table book (\r\n  id numeric,\r\n  title varchar(128),\r\n  author varchar(256),\r\n  constraint pk_book primary key (id)\r\n);<\/code><\/pre>\n
Secondly, let’s apply the migration:<\/p>\n
.\/flyway migrate<\/code><\/pre>\n
2.2. Simulate Rollback<\/h3>\n
<\/div>\n
Then, at some point, say we need to reverse the last migration.<\/p>\n
In order to\u00a0restore the database to before the book<\/em> table was created, let’s create migration called\u00a0V2_0__drop_table_book.sql<\/em>:<\/p>\n
drop table book;<\/code><\/pre>\n
Next, let’s apply the migration:<\/p>\n
.\/flyway migrate<\/code><\/pre>\n
Finally, we can check the history of all the migrations using:<\/p>\n
.\/flyway info<\/code><\/pre>\n
which gives us the following output:<\/p>\n
+-----------+---------+-------------------+------+---------------------+---------+\r\n| Category  | Version | Description       | Type | Installed On        | State   |\r\n+-----------+---------+-------------------+------+---------------------+---------+\r\n| Versioned | 1.0     | create book table | SQL  | 2020-08-29 16:07:43 | Success |\r\n| Versioned | 2.0     | drop table book   | SQL  | 2020-08-29 16:08:15 | Success |\r\n+-----------+---------+-------------------+------+---------------------+---------+<\/code><\/pre>\n
Notice that our second migration ran successfully.<\/p>\n
As far as Flyway is concerned, the second migration file is just another standard migration. The actual restoring of the database to the previous version is done entirely through SQL. For example, in our case, the SQL of dropping the table is the opposite of the first migration, which creates the table.<\/p>\n
Using this method, the audit trail doesn’t show us that the second migration is related to the first<\/strong>, as they have different version numbers.\u00a0In order to get such an audit trail, we need to use Flyway Undo.<\/p>\n
3. Using Flyway Undo<\/h2>\n
<\/div>\n
Firstly, it’s important to note that Flyway Undo is a commercial feature of Flyway and isn’t available in the Community Edition.<\/strong> Therefore, we’ll need either the Pro Edition or Enterprise Edition in order to use this feature.<\/p>\n
3.1. Create Migration Files<\/h3>\n
<\/div>\n
First, let’s create a migration file called\u00a0V1_0__create_book_table.sql<\/em>:<\/p>\n
create table book (\r\n  id numeric,\r\n  title varchar(128),\r\n  author varchar(256),\r\n  constraint pk_book primary key (id)\r\n);<\/code><\/pre>\n
Secondly, let’s create the corresponding undo migration file U1_0__create_book_table.sql<\/em>:<\/p>\n
drop table book;<\/code><\/pre>\n
In our undo migration, notice how the filename prefix is ‘U’ compared with the normal migration prefix of ‘V’. Also, in our undo migration files, we write the SQL that reverses the changes of the corresponding migration file<\/strong>. In our case, we’re dropping the table that’s created by the normal migration.<\/p>\n
3.2. Apply Migrations<\/h3>\n
<\/div>\n
Next, let’s check the current state of the migrations:<\/p>\n
.\/flyway -pro info<\/code><\/pre>\n
This gives us the following output:<\/p>\n
+-----------+---------+-------------------+------+--------------+---------+----------+\r\n| Category  | Version | Description       | Type | Installed On | State   | Undoable |\r\n+-----------+---------+-------------------+------+--------------+---------+----------+\r\n| Versioned | 1.0     | create book table | SQL  |              | Pending | Yes      |\r\n+-----------+---------+-------------------+------+--------------+---------+----------+\r\n<\/code><\/pre>\n
Notice the last column, Undoable<\/em>, which indicates Flyway has detected an undo migration file that accompanies our normal migration file.<\/p>\n
Next, let’s apply our migrations:<\/p>\n
.\/flyway migrate<\/code><\/pre>\n
When it completes, our migrations are complete, and our schema has a new book table:<\/p>\n
                List of relations\r\n Schema |         Name          | Type  |  Owner   \r\n--------+-----------------------+-------+----------\r\n public | book                  | table | baeldung\r\n public | flyway_schema_history | table | baeldung\r\n(2 rows)\r\n<\/code><\/pre>\n
3.3. Rollback the Last Migration<\/h3>\n
<\/div>\n
Finally, let’s undo the last migration using the command line:<\/p>\n
.\/flyway -pro undo<\/code><\/pre>\n
After the command has run successfully, we can check the status of the migrations again:<\/p>\n
.\/flyway -pro info<\/code><\/pre>\n
which gives us the following output:<\/p>\n
+-----------+---------+-------------------+----------+---------------------+---------+----------+\r\n| Category  | Version | Description       | Type     | Installed On        | State   | Undoable |\r\n+-----------+---------+-------------------+----------+---------------------+---------+----------+\r\n| Versioned | 1.0     | create book table | SQL      | 2020-08-22 15:48:00 | Undone  |          |\r\n| Undo      | 1.0     | create book table | UNDO_SQL | 2020-08-22 15:49:47 | Success |          |\r\n| Versioned | 1.0     | create book table | SQL      |                     | Pending | Yes      |\r\n+-----------+---------+-------------------+----------+---------------------+---------+----------+<\/code><\/pre>\n
Notice how the undo has been successful, and the first migration is back to pending. Also, in contrast to the first method, the audit trail clearly shows the migrations that were rolled back.<\/strong><\/p>\n
Although Flyway Undo can be useful, it assumes that the whole migration has succeeded.<\/a> For example, it may not work as expected if a migration fails partway through.<\/p>\n
4. Conclusion<\/h2>\n
<\/div>\n
In this short tutorial, we looked at restoring our database using a standard migration. We also looked at the official way of rolling back migrations using Flyway Undo. As usual, all of our code that relates to this tutorial can be found over on GitHub.<\/a><\/p>\n
The post Rolling Back Migrations with Flyway<\/a> first appeared on Baeldung<\/a>.<\/p>\n
\"\"<\/p>\n
<\/a> <\/a> <\/a> <\/a> <\/a> <\/a> <\/a> <\/a> <\/div>\n\n
\\\"IT\u96fb\u8166\u88dc\u7fd2
\u7acb\u523b\u8a3b\u518a\u53ca\u5831\u540d\u96fb\u8166\u88dc\u7fd2\u8ab2\u7a0b\u5427!<\/figcaption><\/figure>\r\n<\/br>Find A Teacher Form:\r\n<\/br>https:\/\/docs.google.com\/forms\/d\/1vREBnX5n262umf4wU5U2pyTwvk9O-JrAgblA-wH9GFQ\/viewform?edit_requested=true#responses\r\n<\/br><\/br>Email:\r\n<\/br>public1989two@gmail.com






\r\nwww.itsec.hk<\/a>
\r\nwww.itsec.vip<\/a>
\r\nwww.itseceu.uk<\/a>
<\/p>","protected":false},"excerpt":{"rendered":"
Learn how to safely roll back migrations using Flyway.<\/p>\n
The post Rolling Back Migrations with Flyway<\/a> first appeared on Baeldung<\/a>.<\/p>\n
<\/a> <\/a> <\/a> <\/a> <\/a> <\/a> <\/a> <\/a> <\/div>\n<\/div>","protected":false},"author":214,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"slim_seo":{"title":"Rolling Back Migrations with Flyway - ITTeacherITFreelance.hk","description":"Learn how to safely roll back migrations using Flyway. The post Rolling Back Migrations with Flyway first appeared on Baeldung .         &nb"},"footnotes":""},"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/itteacheritfreelance.hk\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/69154"}],"collection":[{"href":"https:\/\/itteacheritfreelance.hk\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itteacheritfreelance.hk\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itteacheritfreelance.hk\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/214"}],"replies":[{"embeddable":true,"href":"https:\/\/itteacheritfreelance.hk\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=69154"}],"version-history":[{"count":8,"href":"https:\/\/itteacheritfreelance.hk\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/69154\/revisions"}],"predecessor-version":[{"id":76643,"href":"https:\/\/itteacheritfreelance.hk\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/69154\/revisions\/76643"}],"wp:attachment":[{"href":"https:\/\/itteacheritfreelance.hk\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=69154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itteacheritfreelance.hk\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=69154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itteacheritfreelance.hk\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=69154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}