Hi, I'd like to move all my data from an MS SQL database to a Drupal MySQL database. I don't know the best process to do this and I'm asking for help.

Since the data is not great I was thinking of first exporting the content from MS SQL to CSV and then normalizing the data from the CSV files in a separate MySQL database...exporting it again (this time from MySQL) to CSV once normalized and improved and then importing into Drupal using Feeds Tamper or some other module specific to that purpose.

Does this make sense or is there a better way to do it?