I would like to receive some input on how you guys would approach the following:
We have an internal Projects Database application that was intially developed in ColdFusion and Microsoft SQL, approx. 5 - 6 years ago.
We now want to rebuild the entire application on the Drupal platform (with entities) and of course a Mysql Database, so far so good.
I am wondering how we approach the datamigration from one platform to the other. Basicly we want to migrate all the database records to the new Drupal database structure once the project is finished.
-> Do we need to try and match the database structures when we are developing the platform in Drupal? Or will we have to write a migration script that matches all records one-by-one anyway?
-> Are there tools out there that can assist us in this project?
Developing the new, empty Drupal platform is not a big deal, it's a lot of work (a lot of fields and views basicly), it's the data migration from the old one to the new one that i would like to receive some opinions on.
Thanks for your advice in advance!