Migrating oracle Database tables to AEM pages creation

[Former Community Member]

Hi All,

I got the requirement like migrate the oracle table content into aem pages,what is best practice to develop this?

It would be great help if some one address this is requirement.

Thanks in advance.

Thanks,

Nani

[Jörg_Hoh]

Hi,

This is a major task (besides the whole technical and programming aspect), because at this point you need to know how to structure your site (aka content structure) and also how your templates and components are built. So from my point of view this isn't an easy task, and it takes a good amount of design, planning and time to execute it with a good outcome?

And regarding your question: Is there an API available from your CMS which allows to export pages as XML? Going down to raw SQL is always possible but I recommend to avoid it, because at this point you need to know the SQL structures by heart so you don't mess up your pages or miss things.

Jörg