Migrating Legacy Data 3.57 http://spkr8.com/t/3749

Speakers

Description:

Rob Kaufman and Patrick Crowley from San Diego Ruby will demonstrate how to make legacy data migration simple, easy, and repeatable; allowing developers to seed new apps with existing data very early in the development process and fine-tune migrations right up until it's time to launch.

Legacy migration basics

  • Adding a legacy database adapter
  • Setting up legacy models
  • Mapping legacy fields to existing model attributes
  • Building migration rake tasks
  • Using helper methods to reformat data

Advanced migrations

  • Text encoding issues
  • Non-relational stores (CSV, XML, wikis, etc.)
  • MsSQL and other databases

Deployment strategies

  • Migrating in production on a typical Rails host
  • Migrating for Heroku users

Comments on this Talk

Mug2013 Aaron Sumner, 16 Jul 06:38 PM

Perfect timing--I have to tackle a Rails to Rails and this will save me a good deal of time.

Stream.2400 winescout, 16 Jul 06:43 PM

Informative, thanks. I love simple solutions to complex problems. You had a deep knowledge of the problem. Discussion afterwards was just as interesting as the talk itself.

Stream.2657 cdumler, 16 Jul 07:00 PM

Great project.

Stream.24718 markborcherding, 20 Jul 01:50 PM

Probably a consequence of a short, 30 minute time slot, but I was left with a lot of questions about how the T of ETL is handled. Especially with legacy data, there is usually a change of shape and/or normalization.

Have an account? Sign in or register.

Leave a Comment

21 Ratings: 3.57

Delivery: 3.67

Content: 3.47

Last Five Ratings

Time & Location

July 16, 2010 — 01:15 PM
Kansas City, MO (Map It)