Support Forum

If you can massage the source data using SQL queries to update some columns then things might get easier. Let's see if I can come up with an order. This might not be perfect but it is more or less correct I believe.

1. Source: Change all the user_id of the WP Users and UserMeta tables and the user_id of the SP sfmembers table to enable them to be added to the Target. So basically you would then be circumventing the current auto-increment of the WP users table after you subsequently copy these records in from source.
2. Copy from source the WP Users, UserMeta and SP sfmembers data.
3. You would need to build the SP sfmemberships as well which assigns each new member to a User Group.
4. Create your new forum on the target and note the forum ID.
5. Update the source sftopics and sfposts tables with the new forum ID from target.
6. Change the source sftopics topic_id column to ensure no clashes with taregt topic_id numbers
7. Change the source sfposts post_id column top ensure no clashes with target post_id numbers
8. Now for the tricky bit! Each sfpost record contains the topic_id (now changed in 6 above) and a user_id (now changed in 1 above) which would need to be changed for each topic record to their new values.
9. At this point you should be able to add the data to the target DB.
10. Then go to the forum admin > toolbox > housekeeping and update the forum indexing for the new forum.

And if I missed anything then as long as you make separate backups from each stage it should then be possible to revert to do again.

I am sure Steve (Mr Papa) will shout if he spots I have missed anything.