A few years back I wrote some sql scripts to convert a Scoop-based community website (dialognow.org) to Drupal. I get occasional requests for these scripts, so here they are. No guarantees, and they are certainly out of date. But they worked for me!
copy_comments_table.sql
copy_stories_table.sql
copy_user_table.sql