{"id":12694,"date":"2021-08-31T15:22:00","date_gmt":"2021-08-31T13:22:00","guid":{"rendered":"https:\/\/blog.ouidou.fr\/?p=12694"},"modified":"2024-08-27T11:32:01","modified_gmt":"2024-08-27T09:32:01","slug":"flyway_comment_gerer_migration_de_base_de_donnees","status":"publish","type":"post","link":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees","title":{"rendered":"Flyway \u2014 comment g\u00e9rer vos migrations de base de donn\u00e9es ?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u00c9crit par Pascal Niyitegeka<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"51fd\"><strong>Qu\u2019est-ce que Flyway ?<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"563c\">Flyway est un outil de migrations de base de donn\u00e9es.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"02de\">Avec la constante \u00e9volution de nos outils informatiques, nos mod\u00e8les de donn\u00e9es sont amen\u00e9s \u00e0 changer souvent. Flyway permet de g\u00e9rer l\u2019historique de ces changements.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"b13a\">C\u2019est un logiciel open source qui nous aidera \u00e0 historiser les modifications faites sur notre base de donn\u00e9es. Que \u00e7a soit pour la cr\u00e9ation, modification ou suppression des tables, colonnes, s\u00e9quences ou lignes dans notre base de donn\u00e9es.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"08ea\"><strong>Cr\u00e9ation du Projet Spring Boot<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"bb7f\">Nous allons utiliser&nbsp;<a href=\"https:\/\/start.spring.io\/\" rel=\"noreferrer noopener\" target=\"_blank\">https:\/\/start.spring.io\/<\/a>&nbsp;pour g\u00e9n\u00e9rer un squelette de notre projet avec les d\u00e9pendances n\u00e9cessaires pour ce projet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"639d\"><strong>Les d\u00e9pendances n\u00e9cessaires :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Spring Web<\/li><li>Lombok<\/li><li>Flyway Migration<\/li><li>PostgresSQL Driver<\/li><li>Spring Data JPA<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"09cd\"><a href=\"https:\/\/start.spring.io\/#!type=maven-project&amp;language=java&amp;platformVersion=2.5.4&amp;packaging=jar&amp;jvmVersion=11&amp;groupId=com.example&amp;artifactId=flyway&amp;name=flyway&amp;description=Demo%20Flyway%20avec%20PostgreSQL&amp;packageName=com.example.flyway&amp;dependencies=web,lombok,flyway,postgresql,data-jpa\" rel=\"noreferrer noopener\" target=\"_blank\">D\u00e9pendences Demo FLyway \u00e0 partir de start.spring.io<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"cfec\">Notre projet, ouvert sur Intellij IDEA, ressemblera \u00e0 ceci<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:896\/1*lx5khymnnp5eIzPRlYD3bw.png\" alt=\"Notre projet ouvert sur Intellij IDEA ressemblera \u00e0 ceci\" loading=\"lazy\" \/><figcaption>Source: Projet initialis\u00e9 sur Intellij IDEA<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"9fed\">D\u00e9finitions des propri\u00e9t\u00e9s<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"25fd\">Nous allons renommer notre fichier&nbsp;<strong>application.properties<\/strong>&nbsp;\u00e0&nbsp;<strong>application.yml.&nbsp;<\/strong>Ceci facilitera la lecture des propri\u00e9t\u00e9s.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"6fba\">Dans ce fichier, nous commen\u00e7ons par d\u00e9finir quel pattern utiliser pour nos messages de logs, puis les connexions \u00e0 notre base de donn\u00e9es puis nous finissons avec les propri\u00e9t\u00e9s flyway.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:1400\/1*6zqlAHmGTc5oRupeHJTs_Q.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source: fichier properties avec les param\u00e8tres flyway &amp; les acc\u00e8s \u00e0 la base de donn\u00e9es<\/figcaption><\/figure>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>locations&nbsp;<\/strong>: Dossier contenant l\u2019ensemble de nos scripts \u00e0 ex\u00e9cuter dans la base de donn\u00e9es.<\/li><li><strong>out-of-order<\/strong>&nbsp;: Permettra d\u2019ex\u00e9cuter les scripts par d\u00e9sordre de version. Si nous avons d\u00e9j\u00e0 migr\u00e9 des donn\u00e9es d\u2019une version 1.0 et 3.0 et que plus tard nous ajoutons une version 2.0. La version 2.0 s\u2019ex\u00e9cutera sans souci. Dans notre cas, cette valeur sera \u00e0&nbsp;<strong>false.<\/strong>&nbsp;Nous souhaitons que les scripts soient sup\u00e9rieurs \u00e0 la derni\u00e8re version. Si 3.0 est la derni\u00e8re version, le 2.0 ne sera pas ex\u00e9cut\u00e9.<\/li><li><strong>baseline-on-migrate<\/strong>&nbsp;: permet de cr\u00e9er la table flyway_schema_history si celle-ci n\u2019existe pas dans notre base de donn\u00e9es. C\u2019est ici qu\u2019on va trouver tous les scripts ex\u00e9cut\u00e9s par Flyway<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"9cd2\">Cr\u00e9ation Mod\u00e8le<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"4d41\">Nous cr\u00e9ons ensuite notre mod\u00e8le en utilisant&nbsp;<strong>lombok&nbsp;<\/strong>pour g\u00e9n\u00e9rer les getter (<strong>@Getter<\/strong>) et setter(<strong>@Setter<\/strong>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"100a\"><strong>@Entity<\/strong>&nbsp;pour dire que c\u2019est une classe \u00e0 persister.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"b48e\"><strong>@Table<\/strong>&nbsp;pour d\u00e9finir le nom de la table. Notre table ayant le m\u00eame nom que cet objet, il est inutile de d\u00e9finir le variable name (<strong>@Table(name=\u2019\u2019utilisateur\u2019\u2019)<\/strong>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"4985\"><strong>@SequenceGenerator<\/strong>&nbsp;pour d\u00e9finir la s\u00e9quence \u00e0 ex\u00e9cuter quand on ins\u00e8re des donn\u00e9es dans cette table<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:1400\/1*X2vKMQKN1d43oJjDMr6PBg.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source : D\u00e9finition mod\u00e8le Utilisateur<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"7602\"><strong>Nommage des scripts Flyway<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"41ab\">Nous proc\u00e9dons par cr\u00e9er ensuite le script sql qui permettra de cr\u00e9er notre table Utilisateur.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"bade\">Nous le positionnerons dans le dossier&nbsp;<strong>resources\/db\/migration<\/strong>. C\u2019est l\u00e0 o\u00f9 flyway ira chercher scripts sql.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ced4\">Le nommage des scripts est la suivante :<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong><em>V1__creation_table_utilisateur.sql<\/em><\/strong><\/p><\/blockquote>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Pr\u00e9fixe :<\/strong>&nbsp;V pour la version<\/li><li><strong>Num\u00e9ro de version&nbsp;<\/strong>: il peut \u00eatre sur un digit ou plusieurs, s\u00e9par\u00e9 par des points.&nbsp;<strong>Ex<\/strong>&nbsp;: 1.12.32.0.98<\/li><li><strong>S\u00e9parateur<\/strong>&nbsp;: 2 underscores (2 tirets du 8) entre le num\u00e9ro de version et la description<\/li><li><strong>Description&nbsp;<\/strong>: S\u00e9parer avec des underscores pour s\u00e9parer les mots. Il est important de le nommer avec l\u2019action des requ\u00eates qui est comprise dans le fichier. Lors de l\u2019ex\u00e9cution, flyway retira les underscores, ce qui en fera un message plus lisible et compr\u00e9hensible pour toute personne qui ira lire la table d\u2019historisation.<\/li><li><strong>Suffixe&nbsp;<\/strong>:&nbsp;<strong>.sql<\/strong><\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:1210\/1*2IL4GT6nZGd6M-zTm9uqOQ.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source : Cr\u00e9ation table utilisateur au format flyway<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:992\/1*11epkonqwQGZboYcHspPLw.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source : Contenu du script&nbsp;<em>V1__creation_table_utilisateur.sql<\/em><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"435d\">Lancement de l\u2019application<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:1400\/1*U--5O1ufdM4ix1KVHsezSQ.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source : Logs lancement application<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"445b\">Le lancement de l\u2019application nous montre qu\u2019une nouvelle table&nbsp;<strong>flyway_schema_history<\/strong>&nbsp;a \u00e9t\u00e9 cr\u00e9\u00e9.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"35b9\">C\u2019est l\u00e0 o\u00f9 nous allons retrouver l\u2019ensemble des scripts ex\u00e9cut\u00e9s avec Flyway.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"cbe7\">Nous remarquons que la version commence \u00e0 1. Ce qui correspond \u00e0 la cr\u00e9ation de la table utilisateur.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:1400\/1*ZrUqS48lYZ10UM-kEnngHg.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source : Visualisation de la 1er \u00e9xecution de flyway sur DBevaer<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"9bda\">Nous retrouvons la table d\u2019historisation des ex\u00e9cutions flyway au nom<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"be90\"><strong>flyway_schema_history<\/strong>&nbsp;avec la 1er ligne qui correspond \u00e0 notre 1er script cr\u00e9\u00e9 au-dessus.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"bc9a\">Cette table est compos\u00e9e des champs suivants :<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Installed_rank&nbsp;<\/strong>: order d\u2019execution des scripts<\/li><li><strong>Version&nbsp;<\/strong>: version pr\u00e9sente dans le nom du script<\/li><li><strong>Description&nbsp;<\/strong>: d\u00e9finit aussi dans le nom du script avec les underscores enlev\u00e9 pour faciliter la lecture<\/li><li><strong>Type&nbsp;<\/strong>: le type de fichier ex\u00e9cuter. Dans notre, cas un SQL<\/li><li><strong>Script&nbsp;<\/strong>: le nom complet du script<\/li><li><strong>Checksum&nbsp;<\/strong>: g\u00e9n\u00e9rer automatiquement pour assurer que les scripts de migration n\u2019ont pas \u00e9t\u00e9 modifi\u00e9s depuis leurs derni\u00e8res ex\u00e9cutions. Il faudra cr\u00e9er un nouveau script si on souhaite modifier la table utilisateur en ajoutant un champ Ex : V1.0.1_ajouter_colonne_age_dans_table_utilisateur.sql<\/li><li><strong>Installed_by&nbsp;<\/strong>: quel utilisateur a lanc\u00e9 la migration des donn\u00e9es<\/li><li><strong>Execution_time&nbsp;<\/strong>: temps d\u2019ex\u00e9cution<\/li><li><strong>Success&nbsp;<\/strong>: \u00e9tat de r\u00e9ussite de l\u2019ex\u00e9cution du script<\/li><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"7a97\">Nous retrouvons aussi notre table&nbsp;<strong>Utilisateur.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:1210\/1*K-c3n5tf0K4sNt-aAXqieg.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source : Visualisation de la table Utilisateur cr\u00e9e sur DBevaer<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"74a8\">Si on relance l\u2019application, flyway n\u2019ex\u00e9cutera pas le script de \u00ab V1__creation_table_utilisateurs.sql \u00bb car il est d\u00e9j\u00e0 pr\u00e9sent dans la table d\u2019historique.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"3d25\">\u00c0 chaque relance de l\u2019application, il v\u00e9rifiera les scripts dans le dossier db\/migration et celle dans la table (flyway_schema_history) pour savoir quels scripts manque et les ex\u00e9cute.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"29d7\">Ajout d\u2019autres scripts flyway<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"9792\">Si on ajoute un nouvel script au nom de \u00ab V2__creation_table_voyage.sql \u00bb, on obtiendra ceci :<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:1210\/1*6Ai0bDSSc646Rvwyg3BwHg.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source : Logs lancement application pour cr\u00e9er table voyage<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"e689\">La version de la base de donn\u00e9es est pass\u00e9e \u00e0 2.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:1210\/1*VwMyLOPGVB15fooBG1acVQ.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source : Visualisation de la 2er \u00e9xecution de flyway sur DBevaer<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"8f88\">Il faut noter que le num\u00e9ro de version de nos scripts doit s\u2019incr\u00e9menter.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"00ce\">Nos futurs scripts devront commencer avec le pr\u00e9fixe \u00ab V3 \u00bb ou bien \u00ab V2.0.1 \u00bb<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"f080\">Si nous ajoutons un script avec une version inf\u00e9rieure (ex : V1.0.32__creation_table_charette.sql) \u00e0 celle pr\u00e9sente dans la table d\u2019historique, flyway g\u00e9n\u00e9rera une exception et n\u2019ex\u00e9cutera pas la requ\u00eate.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"7ceb\">Tout au long du cycle de vie de notre projet, nos mod\u00e8les de donn\u00e9es vont \u00e9voluer. Flyway nous permet de mettre \u00e0 jour ces donn\u00e9es tout en gardant un historique de ces changements<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"7822\">Il suffira de cr\u00e9er un nouveau script.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"d8bf\"><strong>Exemple :<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"b3fc\">Si on souhaite ajouter le prix dans notre objet Voyage cela donnera ceci<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ef76\">On cr\u00e9e un nouveau Script avec le nom suivant&nbsp;<strong>V2.0.1__ajouter_prix_dans_table_voyage.sql<\/strong>&nbsp;avec le contenu suivant<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"5ef0\">alter table voyage<br>add column prix numeric null;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"b7a3\">Nous modifions notre Objet voyage en ajoutant le champ<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"3252\">private BigDecimal prix;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"1a85\">On obtient ceci au lancement de l\u2019application :<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:1210\/1*jBG4AN0L8B8QQpxI6JNX1A.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source : Logs lancement application pour modifier table voyage<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:1400\/1*f4qEksxbu-av6AF0VsEbuA.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source : Visualisation de la 3eme \u00e9xecution de flyway sur DBevaer<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"aa3d\">La table d\u2019historisation a les informations sur les scripts de l\u2019ajout du champ prix.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"5289\">La table voyage a le nouveau champ prix.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"e5d1\">Structure final du Projet<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:820\/1*syzi-mCzpBG9jB5uiTMHkw.png\" alt=\"\" loading=\"lazy\" \/><figcaption>Source : Structure final du projet sur Intellij Idea<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"dad7\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"a48b\">Nous avons vu comment utiliser flyway pour garder l\u2019historique des scripts ex\u00e9cuter sur notre base de donn\u00e9es. Avoir l\u2019ensemble des scripts dans un seul dossier nous permettra facilement de d\u00e9ployer l\u2019application sur diff\u00e9rents environnements. Il suffira juste de lancer l\u2019application sur un environnement de DEV, RECETTE, PRODUCTION ou m\u00eame Docker.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/medium.com\/tag\/flyway?source=post_page-----6479e6df2501---------------flyway-----------------\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00c9crit par Pascal Niyitegeka Qu\u2019est-ce que Flyway ? Flyway est un outil de migrations de base de donn\u00e9es. Avec la constante \u00e9volution de nos outils informatiques,<span class=\"excerpt-hellip\"> [\u2026]<\/span><\/p>\n","protected":false},"author":10,"featured_media":12771,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[34,15],"tags":[],"class_list":["post-12694","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles-techniques","category-dev"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Flyway \u2014 comment g\u00e9rer vos migrations de base de donn\u00e9es ? - Ouidou<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez comment g\u00e9rer efficacement les migrations de bases de donn\u00e9es avec Flyway gr\u00e2ce \u00e0 ce guide d\u00e9taill\u00e9.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Flyway \u2014 comment g\u00e9rer vos migrations de base de donn\u00e9es ? - Ouidou\" \/>\n<meta property=\"og:description\" content=\"D\u00e9couvrez comment g\u00e9rer efficacement les migrations de bases de donn\u00e9es avec Flyway gr\u00e2ce \u00e0 ce guide d\u00e9taill\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees\" \/>\n<meta property=\"og:site_name\" content=\"Ouidou\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-31T13:22:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-27T09:32:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2021\/08\/Graph-QL-19.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1620\" \/>\n\t<meta property=\"og:image:height\" content=\"849\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sara Lourties\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sara Lourties\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees\"},\"author\":{\"name\":\"Sara Lourties\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/person\\\/e1d66085fb7c22ede319ce56adc373a4\"},\"headline\":\"Flyway \u2014 comment g\u00e9rer vos migrations de base de donn\u00e9es ?\",\"datePublished\":\"2021-08-31T13:22:00+00:00\",\"dateModified\":\"2024-08-27T09:32:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees\"},\"wordCount\":1312,\"publisher\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Graph-QL-19.png\",\"articleSection\":[\"Articles Techniques\",\"Dev\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees\",\"name\":\"Flyway \u2014 comment g\u00e9rer vos migrations de base de donn\u00e9es ? - Ouidou\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Graph-QL-19.png\",\"datePublished\":\"2021-08-31T13:22:00+00:00\",\"dateModified\":\"2024-08-27T09:32:01+00:00\",\"description\":\"D\u00e9couvrez comment g\u00e9rer efficacement les migrations de bases de donn\u00e9es avec Flyway gr\u00e2ce \u00e0 ce guide d\u00e9taill\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees#primaryimage\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Graph-QL-19.png\",\"contentUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Graph-QL-19.png\",\"width\":1620,\"height\":849,\"caption\":\"Flyway comment g\u00e9rer vos migrations de base de donn\u00e9s- visuel article technique\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/flyway_comment_gerer_migration_de_base_de_donnees#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Flyway \u2014 comment g\u00e9rer vos migrations de base de donn\u00e9es ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/\",\"name\":\"Blog Ouidou\",\"description\":\"Conseil et expertise en technologies\",\"publisher\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#organization\",\"name\":\"Ouidou\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/image_2022-04-13_150237378.png\",\"contentUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/image_2022-04-13_150237378.png\",\"width\":180,\"height\":180,\"caption\":\"Ouidou\"},\"image\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/person\\\/e1d66085fb7c22ede319ce56adc373a4\",\"name\":\"Sara Lourties\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g\",\"caption\":\"Sara Lourties\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Flyway \u2014 comment g\u00e9rer vos migrations de base de donn\u00e9es ? - Ouidou","description":"D\u00e9couvrez comment g\u00e9rer efficacement les migrations de bases de donn\u00e9es avec Flyway gr\u00e2ce \u00e0 ce guide d\u00e9taill\u00e9.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees","og_locale":"fr_FR","og_type":"article","og_title":"Flyway \u2014 comment g\u00e9rer vos migrations de base de donn\u00e9es ? - Ouidou","og_description":"D\u00e9couvrez comment g\u00e9rer efficacement les migrations de bases de donn\u00e9es avec Flyway gr\u00e2ce \u00e0 ce guide d\u00e9taill\u00e9.","og_url":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees","og_site_name":"Ouidou","article_published_time":"2021-08-31T13:22:00+00:00","article_modified_time":"2024-08-27T09:32:01+00:00","og_image":[{"width":1620,"height":849,"url":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2021\/08\/Graph-QL-19.png","type":"image\/png"}],"author":"Sara Lourties","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Sara Lourties","Dur\u00e9e de lecture estim\u00e9e":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees#article","isPartOf":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees"},"author":{"name":"Sara Lourties","@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/person\/e1d66085fb7c22ede319ce56adc373a4"},"headline":"Flyway \u2014 comment g\u00e9rer vos migrations de base de donn\u00e9es ?","datePublished":"2021-08-31T13:22:00+00:00","dateModified":"2024-08-27T09:32:01+00:00","mainEntityOfPage":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees"},"wordCount":1312,"publisher":{"@id":"https:\/\/ouidou.fr\/blog\/#organization"},"image":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees#primaryimage"},"thumbnailUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2021\/08\/Graph-QL-19.png","articleSection":["Articles Techniques","Dev"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees","url":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees","name":"Flyway \u2014 comment g\u00e9rer vos migrations de base de donn\u00e9es ? - Ouidou","isPartOf":{"@id":"https:\/\/ouidou.fr\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees#primaryimage"},"image":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees#primaryimage"},"thumbnailUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2021\/08\/Graph-QL-19.png","datePublished":"2021-08-31T13:22:00+00:00","dateModified":"2024-08-27T09:32:01+00:00","description":"D\u00e9couvrez comment g\u00e9rer efficacement les migrations de bases de donn\u00e9es avec Flyway gr\u00e2ce \u00e0 ce guide d\u00e9taill\u00e9.","breadcrumb":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees#primaryimage","url":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2021\/08\/Graph-QL-19.png","contentUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2021\/08\/Graph-QL-19.png","width":1620,"height":849,"caption":"Flyway comment g\u00e9rer vos migrations de base de donn\u00e9s- visuel article technique"},{"@type":"BreadcrumbList","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/flyway_comment_gerer_migration_de_base_de_donnees#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/ouidou.fr\/blog\/"},{"@type":"ListItem","position":2,"name":"Flyway \u2014 comment g\u00e9rer vos migrations de base de donn\u00e9es ?"}]},{"@type":"WebSite","@id":"https:\/\/ouidou.fr\/blog\/#website","url":"https:\/\/ouidou.fr\/blog\/","name":"Blog Ouidou","description":"Conseil et expertise en technologies","publisher":{"@id":"https:\/\/ouidou.fr\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ouidou.fr\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/ouidou.fr\/blog\/#organization","name":"Ouidou","url":"https:\/\/ouidou.fr\/blog\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2022\/04\/image_2022-04-13_150237378.png","contentUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2022\/04\/image_2022-04-13_150237378.png","width":180,"height":180,"caption":"Ouidou"},"image":{"@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/person\/e1d66085fb7c22ede319ce56adc373a4","name":"Sara Lourties","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g","caption":"Sara Lourties"}}]}},"_links":{"self":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts\/12694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/comments?post=12694"}],"version-history":[{"count":4,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts\/12694\/revisions"}],"predecessor-version":[{"id":12772,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts\/12694\/revisions\/12772"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/media\/12771"}],"wp:attachment":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/media?parent=12694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/categories?post=12694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/tags?post=12694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}