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
88
migrationツールについて
carotene4035
December 18, 2018
Tweet
Share
More Decks by carotene4035
See All by carotene4035
GraphQLのN+1問題を解決したい
carotene4035
1
220
読者を置き去りにする技術
carotene4035
13
8.2k
Aws is emotional.
carotene4035
2
280
名称未設定.pdf
carotene4035
0
210
AWSネットワーク入門
carotene4035
3
320
adtech history
carotene4035
0
75
ファイルアクセスに関する脆弱性
carotene4035
0
110
僕らだけのアニメを放映する
carotene4035
3
1.3k
使いやすい広告管理画面について考えてみる
carotene4035
0
47
Featured
See All Featured
Being A Developer After 40
akosma
91
590k
Designing Experiences People Love
moore
142
24k
Stop Working from a Prison Cell
hatefulcrawdad
271
21k
Site-Speed That Sticks
csswizardry
11
880
Context Engineering - Making Every Token Count
addyosmani
5
180
What's in a price? How to price your products and services
michaelherold
246
12k
Building an army of robots
kneath
306
46k
The Straight Up "How To Draw Better" Workshop
denniskardys
237
140k
BBQ
matthewcrist
89
9.8k
Building Applications with DynamoDB
mza
96
6.6k
Designing for humans not robots
tammielis
254
25k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
48
9.7k
Transcript
migration πʔϧʹ͍ͭͯ Carotene4035
։ൃதʹࠔΔ͜ͱ • ζϨ • ։ൃڥͷζϨ • ιʔείʔυͷόʔδϣϯͷζϨ • ڥมͷζϨ •
DBͷεΩʔϚͷζϨ
DBεΩʔϚͷζϨ • ιʔείʔυಉ͡ɺ ͰDBεΩʔϚ͕ζϨ͍ͯΔͱΤϥʔ͕ͰΔ ʢଘࡏ͠ͳ͍ΧϥϜΛࢀরͯ͠͠·ͬͨΓͳͲʣ • ։ൃڥͱຊ൪ڥͰDBεΩʔϚ͕ζϨΔͱ ҙਤ͠ͳ͍όά͕͋Δ͔
ζϨΛ͙ʹ • ͦͷ̍ confluenceͳͲͷπʔϧͰཧ • ͦͷ̎ migrationπʔϧͰཧ
ͦͷ̍ • confluenceͳͲͰཧ • ॳΊશ෦createจͰཧ • ঃʑʹalterจΛͳΒͯεΩʔϚมߋΛ͚Ճ͍͑ͯ͘ • نʹΑͬͯಛʹͳ͍
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮ͜ͷڥͰɺͲͷalter·Ͱྲྀ͚ͨͬ͠ʯ • ڥ͝ͱʹͲ͜·Ͱྲྀ͔ͨ͠ΛϝϞ͢ΕOK
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮࣗͷڥͰͲ͜·Ͱྲྀ͚ͨͬ͠…ʯ • ͓͚֮͑ͯOKʢ͠ΜͲ͘ͳ͖ͬͯͨʣ
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮࠓͷιʔείʔυͷ࣌ͬͯͲ͏͍͏εΩʔϚ͚ͩͬʯ
ζϨΛ͙ʹ • ʮͲͷڥʯͰʮͲͷSQLʯΛʮͲ͜·Ͱྲྀ͍ͯ͠Δ͔ʯ ͕Θ͔͚ΕΑ͍
ͦͷ̎ • migrationπʔϧ • ʮͲ͜·Ͱྲྀ͔ͨ͠ʯΛςʔϒϧ্Ͱཧ • ʮͲͷڥʯͰʮͲ͜·Ͱྲྀ͍ͯ͠Δ͔ʯ͕Θ͔Δ • ͔͠ɺ·ͩྲྀ͍ͯ͠ͳ͍sqlΛྲྀ͢ʹ sql-migrate
up ͱ͢Δ͚ͩͰྲྀΕΔ
͚ͬ͜͏͍Ζ͍Ζ͋Δ
࣮ԋ