C# – How to migrate existing data with Subsonic migration

csubsonicsubsonic-active-record

I watched the http://www.subsonicproject.com/docs/Using_SimpleRepository screencast, but I am left wondering… how do you migrate existing data? Assume you decided to split a Name property into a FirstName and LastName. How do you do this in Subsonic?

Best Answer

You need to implement the data migration manually. There are several options you can choose from:

  • SQL scripts
  • write a simple program
  • use an ETL Tool like SSIS or Talend