Importing SQL databases The website I am creating needs to import a medium sized database into my new Drupal system.  I will be able to do an SQL export on the old database but I am wondering if there is a good module that my facilitate this kind of transfer.  Also, I might like to make some changes to the structure of the database, for example one table I will need to import has 39 integer that I would like to move into one single vector, is this something I could do with an existing module or would I need to write some php code to handle this?
The Migrate module, not to be confused with Backup &amp; Migrate, can provide this functionality. The project page says it better than I can.


  The migrate module provides a flexible framework for migrating content into Drupal from other sources (e.g., when converting a web site from another CMS to Drupal). Out-of-the-box, support for creating core Drupal objects such as nodes, users, and comments is included - it can easily be extended for migrating other kinds of content.


Deliberately, it's fairly complicated module. Here's a talk on it from DrupalCon denver