I have some data in an access database and I want to move this to my new
SqlServer2005 database. However the schema of the database has changed
significantly, it’s been normalised and various tables have been added,
so the data won’t fit in exactly without first being ‘cleaned’ so to
I was just wondering whether you think I could write some kind of ruby
script to automate some of it, whether anyone has done something
similar, or if there’s a better way of doing this.
Fairly open question I know, but I want to know how others would go
about doing this before I embark upon it.