We've done a lot of migrations from a lot of different CMS's. Our approach is:
- Evaluate all content on old system and determine which modules in mojoPortal will be used for all content.
- Create a list of all of the pages in the old system and then use that list to populate the mojoPortal mp_Pages table. For page hierarchy, we create put our top-level pages first in the list, and determine their page id ourselves. We then add second level pages and enter the corresponding parent page id in our list. We continue for each level of pages until we have all pages listed. This can take a bit of time but if the old CMS has a similar way of storing pages, we don't have to do as much work. After creating pages in SQL, you'll want to restart the application pool for the site so the Site Map cache is rebuilt.
- Using the populated mp_Pages table, we create entries in the mp_FriendlyUrls table for each page.
- Importing content is very dependent on the module which will be used for the content on the mojoPortal site. Often it is easier to simply create the module instance and populate it manually.
If you would rather have someone else do this work for you, we can do it, just send me an email at joe (at) i7media [dot] com.
Hope this helps,