: Merge two existing forms together, Add PHPBB2.x posts in to an existing SMF1.1x I have two community website each running their own forms and I would like to merge the content of both forum

@Cofer257

This is a very difficult task due to the certainty of conflicting IDs and users. Like your link suggests, you'll first have to check for any duplicate users. Aside from that, every post and user should have a unique ID, and those IDs will be referenced in many places (e.g. the userid would be referenced in the posts table).

One solution I have used in a similar situation is to add a number to all the IDs in one database. If you have, say, 3k users, add 5,000 to all user IDs, across all the tables they are referenced in that database. Do the same with individual posts (probably need to add 100,000 or more). And the same for anything else with unique IDs.

After that, you can copy the data to the other database. Obviously, do this on a test server first (e.g. localhost).

Of course, the other answer is to scrap all the old posts and start again - is a discussion from 2005 all that useful?

Vote Up Vote Down