Doing blog migration from wordpress and drupal, below are the basic guidelines if you plan to use a brute migration. It is only advisable to do this for total blogs of less than a thousand.
1. Map tables and fields from database source to destination.
2. Generate the select query statement and make use 'AS' keyword to assign the target field
3. From your sql viewer export the queried data to a INSERT formmatted query.
4. Run the generated statements and wholah data has been migrated.
Kinda wierd writing this items, it is more like a reminder next time I try to do another brute migration.