Export just Few Pages (Parent and child) from one Kentico instance to another.

jason zerr asked on November 26, 2018 17:18

Is it possible to achieve this with some sort of database operations or something else.

I know this question has been asked few times, but in my situation I do not have the staging module setup, and with some research found out it is not possible with the standard export procedures. I am trying to export few pages from a development setup to a staging environment which do not exactly reflect one another.

Recent Answers


Peter Mogilnitski answered on November 26, 2018 18:16 (last edited on November 26, 2018 18:29)

Unfortunately import/export export site objects will not let you do that. You may try with Kentico import toolkit. There is example how to export produts, the same process should apply to pages.

1 votesVote for this answer Mark as a Correct answer

jason zerr answered on November 26, 2018 19:07 (last edited on November 26, 2018 19:08)

Peter, Thanks for the heads up with Kentico Import Toolkit, I am quite sure that I would need to do it with a SQL Database but are there any examples of what the query should look like when exporting pages.

0 votesVote for this answer Mark as a Correct answer

Peter Mogilnitski answered on November 26, 2018 21:13

It depends on what you want to do, Pages structure is bit complex. I geuss you want to create a record in 3 tables: CMS_Tree, CMS_Document and CONTENT_<doc type>?

0 votesVote for this answer Mark as a Correct answer

Peter Mogilnitski answered on November 27, 2018 03:36

Actually i think it is a good idea to use REST service for this purpose. creating and updating pages involves quite a few tables, so usually you use api to avoid any conflicts. Try to get pages using rest on your dev server and then update the prod server.

1 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on November 27, 2018 08:28

Just to add to what Peter said - you can consider using Content staging as well.

0 votesVote for this answer Mark as a Correct answer

jason zerr answered on November 27, 2018 16:07

Thanks Juraj and Peter I will post the approach that I took and probably the why behind it too once I get this done.

0 votesVote for this answer Mark as a Correct answer

jason zerr answered on November 30, 2018 22:07

Hi Guys although I was confident I am going to get it,I am still struggling I was able to enable and make some get requests but I am not quite sure if I have the full picture with any of these approaches.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.