Migrating Kentico 8 website

Olu Dare asked on January 12, 2015 16:54

Hi, I moved my kentico 7 website to a new server. I detached the db from the old server and attached on the new one. I then copied all the files to the new server but i keep getting a series of invalid object errors when i browse the site.(www.documentti.com)

Invalid object name 'View_CONTENT_MenuItem_Joined'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'View_CONTENT_MenuItem_Joined'.

please help

migration kentico 8 free edition

Recent Answers

Brenden Kehren answered on January 12, 2015 18:06

The title of your question is "Migrating Kentico 8 Website". Did you actually do an upgrade from v7.x to 8.x or did you simply move your instance from one server to another?

There is a good chance that the sql user doesn't have dbo access to the objects that were created. OR if you changed the schema from dbo to something else it could have issues with that. If you're on a shared hosting provider sometimes they don't give you dbo access so they create a schema (typically based off of usename) and assign those newly created objects to that schema.

1 votesVote for this answer Mark as a Correct answer

Olu Dare answered on January 16, 2015 14:52

Thanks Brenden, i moved an instance of v7 from one server to another. I have also given the sql user dbo access on all objects but i still get the errors

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on January 25, 2015 18:17

Hi,

Just to be sure, I guess you did it - is that view listed in the DB objects, in the Views section? What is the DB schema/owner set for the objects?

0 votesVote for this answer Mark as a Correct answer