So we've been tasked to migrate a Kentico (I think it's v7.0 according to the dll version) based site to another (non-.NET) solution.The site is fairly small.

Of course in order to migrate the old site to the new we must keep the old content and also the old URLs. The old URLs have .aspx at the end of course. We'd like to have them all throw a HTTP 301 to the new ones.

I am not a .NET dev and I've been snooping around Kentico's DB and Web Interface for a while now. I've narrowed it down to the CMS_Document table. :) I know and have found the following fields:

DocumentPageTitle
DocumentPageKeyWords
DocumentPageDescription
DocumentContent

All are straight forward.

Can anyone provide concrete information on where to look for the connection URL -> DB Entry -> Web Page on the same URL?

But what about DocumentUrlPath? If there is see /example can I be sure that this is equal to a real URL like /example.aspx?

Which table does DocumentForeignKeyValue point to?

How do I distinguish pages from images in that table? Yes there is the DocumentType field but it only has an file extension (like .png) stored for text and picture files and it seems to be NULL for others?

Are my conclusions so far correct? Thank you for your time.