From: Richard Dowden Date: 2007-10-24T21:12:16+09:00 Subject: Using ruby to transfer and clean data between databases Hi all, 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 speak. 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. Cheers, Daf -- Posted via http://www.ruby-forum.com/.