Portal Engine Questions on portal engine and web parts.
Version 5.x > Portal Engine > Migrating content to Kentico View modes: 
User avatar
Member
Member
Armysniper89 - 5/10/2011 7:28:28 PM
   
Migrating content to Kentico
I have a site written in Ektron that I am moving to Kentico. We have ported the content fmor Ektron into tables in a database. I would like to know what the most efficient methodology would be to move this content from the tables to Kentico. Is it safe to simply call some stored procedures in the Kentico database to migrate the content or should I call API's and create a tool to do the work?

User avatar
Member
Member
lance-digitalle - 5/11/2011 2:31:10 AM
   
RE:Migrating content to Kentico
I don't know Ektron, but it looks like it's a .NET solution. You probably want to use the 'CMS Import Toolkit' from Kentico. It's a nice tool used to import into Kentico from another SQL server database.

Find it here: http://devnet.kentico.com/Blogs/Martin-Hejtmanek/April-2011/Kentico-CMS-Import-Toolkit-5-5R2-Alpha-2.aspx

You can use it to import most types of objects, but note that it's a 'stable' Alpha. I've been using it this week, and it's pretty good!

User avatar
Member
Member
Armysniper89 - 5/11/2011 4:03:16 PM
   
RE:Migrating content to Kentico
Well the Ektron part does not matter as the data is being scrubbed of Ektron garbage and being put into a database table structure of my choosing. I will check out the import tool. At the very least it might get me part way there.

User avatar
Member
Member
Armysniper89 - 5/11/2011 4:06:13 PM
   
RE:Migrating content to Kentico
Lets say though that the tool does not do the trick. Would the best bet to be to use API calls or does the API simply use the SQL Stored Procs of the database to do the trick. Would be easier from a mechanical methodology to use the SQL method but if the API's do some extra work before calling the stored procedures, then I would want to go that route. Someone from Kentico want to jump in on this one?

User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 5/12/2011 2:53:07 AM
   
RE:Migrating content to Kentico
Hello,


if the Import toolkit does not help, I would recommend you using API to create documents. Please do not import data by SQL methods because there are dependencies in another tables.

You can find the API sample code here: Creating documents. You can find more code snippets in that chapter of Developer's Guide.


Best regards,
Helena Grulichova