Class::DBI::DataMigration Getting Your Data From There to Here  
  1. Data Migration
  2. Class::DBI::DataMigration
  3. Class::DBI::DataMigration
  4. 3 Steps, 3 Technologies:
  5. Examples: TransGaming Games Database
  6. Example 1: Mapping Scalar Column Values
  7. Step 1: Specify the source and target databases using Class::DBI
  8. Step 1: Specify the source and target databases using Class::DBI
  9. Step 2: Specify a data structure that maps between source and target databases using YAML
  10. Data::Dumper notation
  11. Data::Dumper notation
  12. The same thing in YAML
  13. YAML
  14. So Far
  15. Step 3: Pass the data structure to Class::DBI::DataMigration::Migrator
  16. How It Works: 3 Main Classes (for now)
  17. How It Works: 2 Big Steps
  18. How It Works: Loops Within Loops
  19. Example 2: Mapping Between To-one Relationships
  20. Example 2: Mapping Between To-one Relationships
  21. Step 1: Specify the source and target databases using Class::DBI
  22. Step 1: Specify the source and target databases using Class::DBI
  23. A Quick Digression: Class::DBI::DataMigration::Mapping::HasAToHasA
  24. Step 2: Specify a data structure that maps between source and target databases using YAML
  25. Step 2: Specify a data structure that maps between source and target databases using YAML
  26. Step 3: Pass the data structure to Class::DBI::DataMigration::Migrator
  27. How It Works: How a Migrator Migrates
  29. How It Works: How a Mapper Maps
  31. How It Works: How a Mapping Maps
  32. Example 3: Mapping an Attribute to a To-one Relationship
  33. Example 3: Mapping an Attribute to a To-one Relationship
  34. Example 3: Class::DBI Code
  35. The Problem
  36. The Solution - code
  37. The Solution - YAML
  38. The Solution - YAML
  39. The script code's still the same!
  40. Example 4: Mapping an Attribute to a New Row with a To-one Relationship
  41. Example 4: Mapping an Attribute to a New Row with a To-one Relationship
  42. Example 4: Mapping an Attribute to a New Row with a To-one Relationship
  43. The Problem
  44. Investigation
  45. Investigation
  46. The Solution: A Custom Mapper Class
  47. The Solution: YAML
  48. The Solution: YAML
  49. The script code's STILL the same!
  50. Synchronization
Copyright © 2005 Dan Friedman (Powered by Spork)