How painful it is to have a database schema change

Programmers who work with databases all day know how painful it is to change the schema of a database. In particular, a well-developed project, as demand changes, the database schema will change, and tracking these changes have always been time-consuming and laborious. If you have multiple test environments, it is more difficult to keep the consistency of the databases in these environments exponentially.

Flyway, a gadget that can be used to greatly simplify this work.

Advantages of it:

1. Convention over configuration, easy to configure, easy to use, support SQL and Java configuration;

2. Support for almost all current mainstream databases;

3. command line tools, Maven, Gradle plugins .... Wide range of application scenarios.

Before using it, you need to understand some concepts:

• Version: Each change to a database can be called a version.

• Migration: Flyway Updating the database structure from one version to another is called migration.

• Available migrations: The migrated version that is recognized by the Flyway file system.

• Migrated already applied: Flyway has already performed a migration to the database.

http://www.italki.com/user/2299987
http://www.italki.com/user/2299989
http://www.italki.com/user/2299991
http://www.italki.com/user/2300283
http://www.italki.com/user/2300287
http://www.italki.com/user/2300296
http://www.italki.com/user/2300491
http://www.italki.com/user/2300486
http://www.italki.com/user/2300493
http://www.italki.com/user/2300531
http://www.italki.com/user/2300536
http://www.italki.com/user/2300685
http://www.italki.com/user/2300689
http://www.italki.com/user/2300694
http://www.italki.com/user/2300961
http://www.italki.com/user/2301097
http://www.italki.com/user/2301113
http://www.italki.com/user/2301114
http://www.italki.com/user/2301230
http://www.italki.com/user/2301242
http://www.italki.com/user/2301247
http://www.italki.com/user/2302220
http://www.italki.com/user/2302221
http://www.italki.com/user/2302259
http://www.italki.com/user/2302270
http://www.italki.com/user/2302271
http://www.italki.com/user/2302317
http://www.italki.com/user/2302331
http://www.italki.com/user/2302327
http://www.italki.com/user/2302388
http://www.italki.com/user/2302389
http://www.italki.com/user/2302494
http://www.italki.com/user/2302495
http://www.italki.com/user/2302511
http://www.italki.com/user/2302766
http://www.italki.com/user/2302759
http://www.italki.com/user/2302769
http://www.italki.com/user/2302873
http://www.italki.com/user/2302912
http://www.italki.com/user/2302976
http://www.italki.com/user/2302990
http://www.italki.com/user/2302999
http://www.italki.com/user/2303341
http://www.italki.com/user/2303362
http://www.italki.com/user/2303378
http://www.italki.com/user/2303481
http://www.italki.com/user/2303513
http://www.italki.com/user/2303507
http://www.italki.com/user/2303703
http://www.italki.com/user/2303718
http://www.italki.com/user/2303716
http://www.italki.com/user/2303968
http://www.italki.com/user/2303973
http://www.italki.com/user/2303977
http://www.italki.com/user/2304008
http://www.italki.com/user/2304040
http://www.italki.com/user/2304033
http://www.italki.com/user/2304099
http://www.italki.com/user/2304109
http://www.italki.com/user/2304111
http://www.italki.com/user/2304681
http://www.italki.com/user/2304680
http://www.italki.com/user/2304691
http://www.italki.com/user/2304748
http://www.italki.com/user/2304755
http://www.italki.com/user/2304759
http://www.italki.com/user/2304901
http://www.italki.com/user/2304910
http://www.italki.com/user/2304914
http://www.italki.com/user/2305208
http://www.italki.com/user/2305222
http://www.italki.com/user/2305228
http://www.italki.com/user/2305297
http://www.italki.com/user/2305310
http://www.italki.com/user/2305311
http://www.italki.com/user/2305687
http://www.italki.com/user/2305702
http://www.italki.com/user/2305723
http://www.italki.com/user/2306125
http://www.italki.com/user/2306135
http://www.italki.com/user/2306133
http://www.italki.com/user/2306372
http://www.italki.com/user/2306417
http://www.italki.com/user/2306423
http://www.italki.com/user/2306486
http://www.italki.com/user/2306503
http://www.italki.com/user/2306505
http://www.italki.com/user/2306624
http://www.italki.com/user/2306635
http://www.italki.com/user/2306653
http://www.italki.com/user/2306711
http://www.italki.com/user/2306717
http://www.italki.com/user/2306724
http://www.italki.com/user/2306800
http://www.italki.com/user/2306791
http://www.italki.com/user/2306824
http://www.italki.com/user/2307620
http://www.italki.com/user/2307648
http://www.italki.com/user/2307655
http://www.italki.com/user/2307982
http://www.italki.com/user/2308058
http://www.italki.com/user/2308125
http://www.italki.com/user/2308152
http://www.italki.com/user/2308156
http://www.italki.com/user/2308231
http://www.italki.com/user/2308273
http://www.italki.com/user/2308306
http://www.italki.com/user/2309031
http://www.italki.com/user/2309061
http://www.italki.com/user/2309063
http://www.italki.com/user/2309212
http://www.italki.com/user/2309245
http://www.italki.com/user/2309227
http://www.italki.com/user/2309353
http://www.italki.com/user/2309409
http://www.italki.com/user/2309425
http://www.italki.com/user/2309422
http://www.italki.com/user/2309521
http://www.italki.com/user/2309509
http://www.italki.com/user/2309554
http://www.italki.com/user/2309696
http://www.italki.com/user/2309710
http://www.italki.com/user/2309700
http://www.italki.com/user/2309808
http://www.italki.com/user/2309848
http://www.italki.com/user/2309875
http://www.italki.com/user/2309947
http://www.italki.com/user/2310008
http://www.italki.com/user/2310016
http://www.italki.com/user/2310139
http://www.italki.com/user/2310120
http://www.italki.com/user/2310152
http://www.italki.com/user/2310791
http://www.italki.com/user/2310784
http://www.italki.com/user/2310804
http://www.italki.com/user/2310952
http://www.italki.com/user/2310906
http://www.italki.com/user/2311456
http://www.italki.com/user/2311470
http://www.italki.com/user/2311467
http://www.italki.com/user/2311560
http://www.italki.com/user/2311573
http://www.italki.com/user/2311582
http://www.italki.com/user/2311901
http://www.italki.com/user/2311918
http://www.italki.com/user/2311914
http://www.italki.com/user/2312122
http://www.italki.com/user/2312149
http://www.italki.com/user/2312140
http://www.italki.com/user/2312255
http://www.italki.com/user/2312272
http://www.italki.com/user/2312287
http://www.italki.com/user/2312346
http://www.italki.com/user/2312371
http://www.italki.com/user/2312378
http://www.italki.com/user/2312493
http://www.italki.com/user/2312526
http://www.italki.com/user/2312527
http://www.italki.com/user/2312752
http://www.italki.com/user/2312771
http://www.italki.com/user/2312789
http://www.italki.com/user/2312893
http://www.italki.com/user/2312930
http://www.italki.com/user/2312933
http://www.italki.com/user/2313029
http://www.italki.com/user/2313047
http://www.italki.com/user/2313078
http://www.italki.com/user/2313562
http://www.italki.com/user/2313566
http://www.italki.com/user/2313578
http://www.italki.com/user/2313643
http://www.italki.com/user/2313668
http://www.italki.com/user/2313657
http://www.italki.com/user/2313947
http://www.italki.com/user/2313967
http://www.italki.com/user/2313957
http://www.italki.com/user/2314070
http://www.italki.com/user/2314096
http://www.italki.com/user/2314079
http://www.italki.com/user/2314728
http://www.italki.com/user/2314726
http://www.italki.com/user/2314740
http://www.italki.com/user/2315007
http://www.italki.com/user/2315027
http://www.italki.com/user/2314991
http://www.italki.com/user/2315235
http://www.italki.com/user/2315278
http://www.italki.com/user/2315297
http://www.italki.com/user/2318220
http://www.italki.com/user/2318331
http://www.italki.com/user/2318320
http://www.italki.com/user/2330987
http://www.italki.com/user/2331024
http://www.italki.com/user/2331071
http://www.italki.com/user/2331303
http://www.italki.com/user/2331380
http://www.italki.com/user/2331463
http://www.italki.com/user/2331555
http://www.italki.com/user/2331834
http://www.italki.com/user/2332008
http://www.italki.com/user/2277118
http://www.italki.com/user/2279224
http://www.italki.com/user/2279756
http://www.italki.com/user/2285635
http://www.italki.com/user/2288304
http://www.italki.com/user/2288521

How painful it is to have a database schema change