Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

dbImportPresentation.pdf

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for Adam Weis Adam Weis
November 28, 2012
34
1

 dbImportPresentation.pdf

Avatar for Adam Weis

Adam Weis

November 28, 2012

More Decks by Adam Weis

See All by Adam Weis
67-311 Data import presentation
Avatar for Adam Weis aweis
1
63

Featured

See All Featured
XXLCSS - How to scale CSS and keep your sanity
Avatar for Zaharenia Atzitzikaki sugarenia
250
1.3M
The State of eCommerce SEO: How to Win in Today's Products SERPs - #SEOweek
Avatar for Aleyda Solis aleyda
2
12k
What’s in a name? Adding method to the madness
Avatar for The Alliance productmarketing
PRO
24
4.2k
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
234
19k
Paper Plane (Part 1)
Avatar for Katie Cordina Lindsey katiecoart
PRO
2
12k
Navigating Team Friction
Avatar for Lara Hogan lara
192
16k
KATA
Avatar for Megan Lloyd mclloyd
PRO
35
16k
Rails Girls Zürich Keynote
Avatar for Gregor Martynus gr2m
96
14k
The World Runs on Bad Software
Avatar for Brandon Keepers bkeepers
PRO
72
12k
Discover your Explorer Soul
Avatar for Emna emna__ayadi
2
1.3k
Information Architects: The Missing Link in Design Systems
Avatar for Michelle Chin soysaucechin
1
1.2k
Neural Spatial Audio Processing for Sound Field Analysis and Control
Avatar for NII S. Koyama's Lab skoyamalab
0
570

Transcript

  1. 67-311 Database Design and Implementation Adam Weis 11/11/12 Wednesday, November

    28, 12

  2. Database Redesign Case study: Wednesday, November 28, 12

  3. Database Redesign Case study: Wednesday, November 28, 12

  4. Fall 2011 Wednesday, November 28, 12

  5. Fall 2011 Wednesday, November 28, 12

  6. Wednesday, November 28, 12

  7. Spring 2013 Wednesday, November 28, 12

  8. Spring 2013 Wednesday, November 28, 12

  9. Wednesday, November 28, 12

  10. Wednesday, November 28, 12

  11. Wednesday, November 28, 12

  12. Wednesday, November 28, 12

  13. ERD - Fall 2011 Wednesday, November 28, 12

  14. ERD - Spring 2013 Wednesday, November 28, 12

  15. Overview Wednesday, November 28, 12

  16. Overview How to upgrade database design? Wednesday, November 28, 12

  17. Overview How to upgrade database design? How to import old

    data? Wednesday, November 28, 12

  18. What changed? Wednesday, November 28, 12

  19. What changed? A lot. Wednesday, November 28, 12

  20. What changed? A lot. Instructors are now a table, not

    a row in Courses Wednesday, November 28, 12

  21. What changed? A lot. Instructors are now a table, not

    a row in Courses Completely new relationships with “Group” join table Wednesday, November 28, 12

  22. What changed? A lot. Instructors are now a table, not

    a row in Courses Completely new relationships with “Group” join table etc. Wednesday, November 28, 12

  23. Migrations Wednesday, November 28, 12

  24. Migrations Awesome for database manipulation Wednesday, November 28, 12

  25. Migrations Awesome for database manipulation Bad with legacy data Wednesday,

    November 28, 12

  26. Solution Wednesday, November 28, 12

  27. Solution Write a database importer script! Wednesday, November 28, 12

  28. Solution Write a database importer script! Query both databases simultaneously

    to import legacy data into new schema! Wednesday, November 28, 12

  29. Database importer Wednesday, November 28, 12

  30. Database importer ingredients Wednesday, November 28, 12

  31. Database importer ingredients Establish a new ActiveRecord connection with old

    database Wednesday, November 28, 12

  32. Database importer ingredients Establish a new ActiveRecord connection with old

    database Recreate all legacy model relationships Wednesday, November 28, 12

  33. Database importer ingredients Establish a new ActiveRecord connection with old

    database Recreate all legacy model relationships Create the to_model methods Wednesday, November 28, 12

  34. Database importer ingredients Establish a new ActiveRecord connection with old

    database Recreate all legacy model relationships Create the to_model methods Write the driver Wednesday, November 28, 12

  35. Example Wednesday, November 28, 12

  36. Citations Wednesday, November 28, 12

  37. Citations Vincent Siao (SCS & HCI 2014) Wednesday, November 28,

    12

  38. Citations Vincent Siao (SCS & HCI 2014) Jason MacDonald (SCS

    2013) Wednesday, November 28, 12

  39. Citations Vincent Siao (SCS & HCI 2014) Jason MacDonald (SCS

    2013) Steven Fackler (SCS 2013) Wednesday, November 28, 12

  40. Citations Vincent Siao (SCS & HCI 2014) Jason MacDonald (SCS

    2013) Steven Fackler (SCS 2013) Tim Riley: http://openmonkey.com/blog/2009/05/02/ importing-legacy-data-in-rails/ Wednesday, November 28, 12

  41. Citations Vincent Siao (SCS & HCI 2014) Jason MacDonald (SCS

    2013) Steven Fackler (SCS 2013) Tim Riley: http://openmonkey.com/blog/2009/05/02/ importing-legacy-data-in-rails/ https://github.com/aweis/rails_importer/blob/master/ S13importer.rb Wednesday, November 28, 12