As I continue to maintain and enhance my application, I am adding new columns and changing properties of existing ones. I am looking for a programmatic way to migrate data from an "old" version of a given table to a "new" version - it would recognize matching column names and transfer the data for all rows and so on. This would be preferable to building a custom migration script for each table every time I change it. Any thoughts?
