Hello Owain, have you had any luck in migrating data from Orchard to Umbraco? I have the same need.

I tried it with the following SQL query:

SELECT t.Title, f.Data, b.Text  FROM dbo.Title_TitlePartRecord t
 inner join dbo.Orchard_Framework_ContentItemRecord f on 
 t.ContentItemRecord_id=f.Id 
  inner join dbo.Common_BodyPartRecord b on 
 b.ContentItemRecord_id=f.Id
  AND  b.Id = (
            SELECT MAX(m2.Id) 
            FROM dbo.Common_BodyPartRecord m2 
            WHERE m2.ContentItemRecord_id = f.Id
        )
  AND  t.Id = (
            SELECT MAX(m2.Id) 
            FROM dbo.Title_TitlePartRecord m2 
            WHERE m2.ContentItemRecord_id = f.Id
        )

The import process seemed to go smoothly, and I can see hundreds of imported blog entries in Umbraco, but they have not contents. They have only titles. They are not automatically published. After I publish one of the imported entries, I get the following error when viewing Blogs:

Server Error in '/' Application. Unable to cast object of type 'Umbraco.Web.PublishedContentModels.Blog' to type 'Umbraco.Web.PublishedContentModels.Blogpost'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Unable to cast object of type 'Umbraco.Web.PublishedContentModels.Blog' to type 'Umbraco.Web.PublishedContentModels.Blogpost'.

Source Error:

Line 20:

Line 21: Line 22:
@foreach (ContentModels.Blogpost post in blogposts) Line 23:
{ Line 24:

Hi, I ended up writing a XML converter but unfortunately I don't have it any more. What is your blog structure in the back office?

I use the default blog structure of Umbraco - the one in start kit - as following:

The importing is sort of working. I have imported the titles and excerpts, but not content. I can understand it because content needs to be added individually for each blog post. I just imported contents to excerpts, and edit them one by one. It is a personal site, and there are not many posts (only a few hundred), so I will just take time to re-publish them one by one. It takes only a few seconds for each of them.

Ye, I probably spent more time writing the converter than what it would have taken if I had just copied the posts over myself one by one. :)