Upgrade path from drupal 6 to drupal 7

So far I've had to do the following to get the program and archive content types to show up. Schedule and playlist upgraded fine. I used content_migrate for the fields.

UPDATE  `node_type` SET  `base` =  'node_content'  WHERE  `node_type`.`type` =  'station_program';
UPDATE  `node_type` SET  `disabled` =  '0'  WHERE  `node_type`.`type` =  'station_program';

UPDATE  `node_type` SET  `base` =  'node_content' WHERE  `node_type`.`type` =  'audio';
UPDATE  `node_type` SET  `disabled` =  '0' WHERE  `node_type`.`type` =  'audio';
UPDATE  `node_type` SET  `module` =  'station_program' WHERE  `node_type`.`type` =  'audio';
UPDATE  `node_type` SET  `orig_type` =  'station_archive' WHERE  `node_type`.`type` =  'audio';
UPDATE  `node_type` SET  `type` =  'station_archive' WHERE  `node_type`.`type` =  'audio';
UPDATE node SET type='station_archive' WHERE type='audio';
UPDATE `field_config_instance` set bundle='station_archive' WHERE bundle='audio';

I'm now working on migrating the audio files to field_station_archive_audio.

I've created a patch for migrating the audio files into the audiofield.

On upgrading I made sure the station modules and their dependencies were installed and enabled in the D6 version.

Had to run the following updates manually otherwise I got errors:

RENAME TABLE  profile_fields TO  profile_field ;
RENAME TABLE  profile_values TO  profile_value ;
RENAME TABLE filter_formats TO filter_format;
ALTER TABLE  `filter_format` ADD  `status` TINYINT UNSIGNED NOT NULL DEFAULT  '1' COMMENT 'The status of the text format. (1 = enabled, 0 = disabled)';
ALTER TABLE  `filter_format` ADD  `weight` INT NOT NULL DEFAULT  '0' COMMENT  'Weight of text format to use when listing.';
ALTER TABLE  `filter_format` ADD INDEX  `status_weight` (  `status` ,  `weight` );
UPDATE  `system` SET  `schema_version` =  '7001' WHERE  `system`.`filename` =  'modules/profile/profile.module';
UPDATE  `system` SET  `schema_version` =  '7000' WHERE  `system`.`filename` =  'modules/filter/filter.module';

And here's the batch script I used for the upgrade:

#!/bin/sh

echo "Importing to kdrt_drupal7 ..."
mysql -u $DB_USER -p$DB_PASS kdrt_drupal7 < kdrt6.sql

echo "Apply updates for filter and profile modules to prevent errors"
mysql -u $DB_USER -p$DB_PASS kdrt_drupal7 < fix-kdrt6.sql

echo "Updating old database"
/usr/local/share/drush/drush -y @kdrt7 updatedb

echo "Enable new modules"
/usr/local/share/drush/drush -y @kdrt7 pm-enable audiofield overlay content_migrate toolbar station_schedule station_program station_playlist station_catalog station_archive station 

echo "Migrate CCK Fields"
/usr/local/share/drush/drush -y @kdrt7 content-migrate-fields field_station_program field_station_playlist_date field_station_program_dj field_station_program_link field_station_program_genre

Better description