Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
migrationツールについて
Search
carotene4035
December 18, 2018
0
78
migrationツールについて
carotene4035
December 18, 2018
Tweet
Share
More Decks by carotene4035
See All by carotene4035
GraphQLのN+1問題を解決したい
carotene4035
1
190
読者を置き去りにする技術
carotene4035
13
8.1k
Aws is emotional.
carotene4035
2
270
名称未設定.pdf
carotene4035
0
200
AWSネットワーク入門
carotene4035
2
300
adtech history
carotene4035
0
69
ファイルアクセスに関する脆弱性
carotene4035
0
100
僕らだけのアニメを放映する
carotene4035
3
1.3k
使いやすい広告管理画面について考えてみる
carotene4035
0
40
Featured
See All Featured
Rails Girls Zürich Keynote
gr2m
94
13k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
27
1.9k
A designer walks into a library…
pauljervisheath
205
24k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
6
570
Music & Morning Musume
bryan
46
6.4k
Docker and Python
trallard
44
3.3k
Building Your Own Lightsaber
phodgson
104
6.2k
Bash Introduction
62gerente
611
210k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
160
15k
Put a Button on it: Removing Barriers to Going Fast.
kastner
60
3.7k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
666
120k
What's in a price? How to price your products and services
michaelherold
244
12k
Transcript
migration πʔϧʹ͍ͭͯ Carotene4035
։ൃதʹࠔΔ͜ͱ • ζϨ • ։ൃڥͷζϨ • ιʔείʔυͷόʔδϣϯͷζϨ • ڥมͷζϨ •
DBͷεΩʔϚͷζϨ
DBεΩʔϚͷζϨ • ιʔείʔυಉ͡ɺ ͰDBεΩʔϚ͕ζϨ͍ͯΔͱΤϥʔ͕ͰΔ ʢଘࡏ͠ͳ͍ΧϥϜΛࢀরͯ͠͠·ͬͨΓͳͲʣ • ։ൃڥͱຊ൪ڥͰDBεΩʔϚ͕ζϨΔͱ ҙਤ͠ͳ͍όά͕͋Δ͔
ζϨΛ͙ʹ • ͦͷ̍ confluenceͳͲͷπʔϧͰཧ • ͦͷ̎ migrationπʔϧͰཧ
ͦͷ̍ • confluenceͳͲͰཧ • ॳΊશ෦createจͰཧ • ঃʑʹalterจΛͳΒͯεΩʔϚมߋΛ͚Ճ͍͑ͯ͘ • نʹΑͬͯಛʹͳ͍
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮ͜ͷڥͰɺͲͷalter·Ͱྲྀ͚ͨͬ͠ʯ • ڥ͝ͱʹͲ͜·Ͱྲྀ͔ͨ͠ΛϝϞ͢ΕOK
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮࣗͷڥͰͲ͜·Ͱྲྀ͚ͨͬ͠…ʯ • ͓͚֮͑ͯOKʢ͠ΜͲ͘ͳ͖ͬͯͨʣ
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮࠓͷιʔείʔυͷ࣌ͬͯͲ͏͍͏εΩʔϚ͚ͩͬʯ
ζϨΛ͙ʹ • ʮͲͷڥʯͰʮͲͷSQLʯΛʮͲ͜·Ͱྲྀ͍ͯ͠Δ͔ʯ ͕Θ͔͚ΕΑ͍
ͦͷ̎ • migrationπʔϧ • ʮͲ͜·Ͱྲྀ͔ͨ͠ʯΛςʔϒϧ্Ͱཧ • ʮͲͷڥʯͰʮͲ͜·Ͱྲྀ͍ͯ͠Δ͔ʯ͕Θ͔Δ • ͔͠ɺ·ͩྲྀ͍ͯ͠ͳ͍sqlΛྲྀ͢ʹ sql-migrate
up ͱ͢Δ͚ͩͰྲྀΕΔ
͚ͬ͜͏͍Ζ͍Ζ͋Δ
࣮ԋ