Upgrade to Pro — share decks privately, control downloads, hide ads and more …

migrationツールについて

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for carotene4035 carotene4035
December 18, 2018
100
0

 migrationツールについて

Avatar for carotene4035

carotene4035

December 18, 2018

More Decks by carotene4035

See All by carotene4035
GraphQLのN+1問題を解決したい
Avatar for carotene4035 carotene4035
1
240
読者を置き去りにする技術
Avatar for carotene4035 carotene4035
13
8.2k
Aws is emotional.
Avatar for carotene4035 carotene4035
2
290
名称未設定.pdf
Avatar for carotene4035 carotene4035
0
220
AWSネットワーク入門
Avatar for carotene4035 carotene4035
3
340
adtech history
Avatar for carotene4035 carotene4035
0
110
ファイルアクセスに関する脆弱性
Avatar for carotene4035 carotene4035
0
120
僕らだけのアニメを放映する
Avatar for carotene4035 carotene4035
3
1.4k
使いやすい広告管理画面について考えてみる
Avatar for carotene4035 carotene4035
0
55

Featured

See All Featured
JAMstack: Web Apps at Ludicrous Speed - All Things Open 2022
Avatar for David Neal reverentgeek
1
480
The innovator’s Mindset - 
Leading Through an Era of Exponential Change - McGill University 2025
Avatar for Jean-Marc De Jonghe jdejongh
PRO
1
210
Google's AI Overviews - The New Search
Avatar for Barry Adams badams
0
1k
Redefining SEO in the New Era of Traffic Generation
Avatar for Szymon Słowik szymonslowik
1
340
AI in Enterprises - Java and Open Source to the Rescue
Avatar for ivargrimstad ivargrimstad
0
1.3k
Practical Orchestrator
Avatar for Shlomi Noach shlominoach
191
11k
The Success of Rails: Ensuring Growth for the Next 100 Years
Avatar for Eileen M. Uchitelle eileencodes
47
8.2k
How People are Using Generative and Agentic AI to Supercharge Their Products, Projects, Services and Value Streams Today
Avatar for Helen Beal helenjbeal
1
220
Unsuck your backbone
Avatar for Amy Palamountain ammeep
672
58k
Java REST API Framework Comparison - PWX 2021
Avatar for Matt Raible mraible
34
9.4k
Believing is Seeing
Avatar for Spiro Bolos oripsolob
1
150
Code Reviewing Like a Champion
Avatar for maltzj maltzj
528
40k

Transcript

  1. migration πʔϧʹ͍ͭͯ Carotene4035

  2. ։ൃதʹࠔΔ͜ͱ • ζϨ • ։ൃ؀ڥͷζϨ • ιʔείʔυͷόʔδϣϯͷζϨ • ؀ڥม਺ͷζϨ •

    DBͷεΩʔϚͷζϨ

  3. DBεΩʔϚͷζϨ • ιʔείʔυ͸ಉ͡ɺ
 Ͱ΋DBεΩʔϚ͕ζϨ͍ͯΔͱΤϥʔ͕ͰΔ
 ʢଘࡏ͠ͳ͍ΧϥϜΛࢀরͯ͠͠·ͬͨΓͳͲʣ • ։ൃ؀ڥͱຊ൪؀ڥͰDBεΩʔϚ͕ζϨΔͱ
 ҙਤ͠ͳ͍όά͕͋Δ͔΋


  4. ζϨΛ๷͙ʹ͸ • ͦͷ̍
 confluenceͳͲͷπʔϧͰ؅ཧ • ͦͷ̎
 migrationπʔϧͰ؅ཧ

  5. ͦͷ̍ • confluenceͳͲͰ؅ཧ • ॳΊ͸શ෦createจͰ؅ཧ • ঃʑʹalterจΛͳΒ΂ͯεΩʔϚมߋΛ෇͚Ճ͍͑ͯ͘ • ن໛ʹΑͬͯ͸ಛʹ໰୊͸ͳ͍

  6. ͦͷ̍ • ߟ͑ΒΕ͏Δ໰୊ • ʮ͜ͷ؀ڥͰ͸ɺͲͷalter·Ͱྲྀ͚ͨͬ͠ʯ • ؀ڥ͝ͱʹͲ͜·Ͱྲྀ͔ͨ͠ΛϝϞ͢Ε͹OK

  7. ͦͷ̍ • ߟ͑ΒΕ͏Δ໰୊ • ʮࣗ෼ͷ؀ڥͰ͸Ͳ͜·Ͱྲྀ͚ͨͬ͠…ʯ • ͓͚֮͑ͯ͹OKʢ͠ΜͲ͘ͳ͖ͬͯͨʣ

  8. ͦͷ̍ • ߟ͑ΒΕ͏Δ໰୊ • ʮࠓͷιʔείʔυͷ࣌ͬͯͲ͏͍͏εΩʔϚ͚ͩͬʯ

  9. ζϨΛ๷͙ʹ͸ • ʮͲͷ؀ڥʯͰʮͲͷSQLʯΛʮͲ͜·Ͱྲྀ͍ͯ͠Δ͔ʯ
 ͕Θ͔͚Ε͹Α͍

  10. ͦͷ̎ • migrationπʔϧ • ʮͲ͜·Ͱྲྀ͔ͨ͠ʯΛςʔϒϧ্Ͱ؅ཧ • ʮͲͷ؀ڥʯͰʮͲ͜·Ͱྲྀ͍ͯ͠Δ͔ʯ͕Θ͔Δ • ͔͠΋ɺ·ͩྲྀ͍ͯ͠ͳ͍sqlΛྲྀ͢ʹ͸
 sql-migrate

    up ͱ͢Δ͚ͩͰྲྀΕΔ

  11. ͚ͬ͜͏͍Ζ͍Ζ͋Δ

  12. ࣮ԋ