Installation and deployment
Version 7.x > Installation and deployment > Kentico, hosting and db schema View modes: 
User avatar
Member
Member
michal.najman-wp - 11/13/2013 5:01:46 AM
   
Kentico, hosting and db schema
Hello All,

I want to move Kentico CMS 7 from one hosting to another. With files there is no problem, but the issue database, so Kentico don't work.

I found that the problem is db schema. Old hosting use different db schema than new hosting. Additionaly, I can't change db schema for users (because it's hosting). So i figured than I can change db schema. I tried many scripts and intruction from Kentico:
http://devnet.kentico.com/getattachment/FAQs/API-and-Internals/How-to-change-owner-schema-of-the-DB-objects/How_to_change_owner_of_DB_objects.pdf.aspx.

All scripts always have problem with for tables:
- CMS_Tree
- CMS_Document
- CMS_Site
- CMS_Class

Manual alter schema doesn't work, because that tables depends from each other.
I also tried Import / Export and also it doesn't works (a lot of exception, site is complex).

Are You moving sites from one hosting to another hosting and could You help me ?

Greetings,
Michał

User avatar
Certified Developer 12
Certified Developer 12
kentico-jx2tech - 11/14/2013 11:09:19 AM
   
RE:Kentico, hosting and db schema
Hi Michał.

We have been extracting the site export zip file and then search for all files that contain the source schema. We then replace occurrences the source schema with the destination schema -- I would suggest using dbo if possible to avoid future upgrade issues. Then zip the modified site export and import it to the new installation.