Migrate Kentico site to new platform

Carl Mason asked on November 27, 2018 19:08

Hi All,

I have a customer that has a multiple site instance of Kentico 10. One of the sites needs to migrate to another CMS system. Most importantly, the site contains many articles that are in a custom page type similar to cms_article and view-able in the cms_tree. I need to export those articles and the associated images to XML so that the customer can import into the new site.

I am looking for thoughts or ideas from anyone that has had to migrate a site to another platform. I did the importing from XML using C# and API some years ago but never worked with API for exporting. Any advice is greatly appreciated.

Thanks, Carl

xml export articles

Recent Answers

Brenden Kehren answered on November 27, 2018 19:41 (last edited on November 27, 2018 19:41)

Can't you use a simple query using T-SQL like so? Of course you'll have to modify which fields you want to query.

SELECT MenuItemName, DocumentName, NodeAliasPath
FROM View_CMS_Tree_Joined
    INNER JOIN Content_MenuItem ON DocumentForeignKeyValue = MenuItemID
WHERE DocumentMenuItemHideInNavigation = 0 AND NodeAliasPath LIKE '/Special-Pages/%'
FOR XML Path('Page'), ROOT('Pages')

1 votesVote for this answer Mark as a Correct answer

Carl Mason answered on November 27, 2018 20:26

Hi Brenden,

That gets me closer. I will need another join or two and then figure out to get at each child image for each article. Articles and images are both in custom page types and articles can have from 0-10+ images as children of parent articles. Sounds like honing in my SQL query to iterate for child images is next clog.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on November 27, 2018 20:38

As long as your images are URLs and not binary data in the database, you'll be able to use a similar query like I showed below. Use left outer joins for the multiple images.

0 votesVote for this answer Mark as a Correct answer

Carl Mason answered on November 27, 2018 21:01

Yep we are storing images on physical file system only as sitename/files and no binary in DB. The reference to images is in the custom page type image table as GUID. Thanks Brenden!

0 votesVote for this answer Mark as a Correct answer