Upgrades Questions on upgrading to version 7.x.
Version 7.x > Upgrades > Error running upgrade from v6 View modes: 
User avatar
Certified Developer v7
Certified  Developer v7
mgrady-galvintech - 11/20/2012 11:32:13 AM
   
Error running upgrade from v6
I am trying to run the last upgrade to v6 on a cms that started on v4 and hit a wall. The upgrader keeps telling me:

"Running SQL script on separated database is currently not supported."

Before running the script I had to alter the schema to change the owner of the objects from "cpuser" to "dbo," would that be causing the issue? If so what would be the best course of action to resolve it?

User avatar
Kentico Support
Kentico Support
kentico_radekm - 12/1/2012 9:48:16 AM
   
RE:Error running upgrade from v6
Hello.

Could you please send an e-mail to support@kentico.com? I was dealing with the same problem few days ago and I could send you some tips by e-mail. I will update this thread then if any of those tips do the trick. Thank you.

Best Regards,
Radek Macalik

User avatar
Member
Member
hithesh-rocketmail - 6/3/2013 10:17:17 AM
   
RE:Error running upgrade from v6
Could you post this tips on this thread please? I'm having this issue too.

Thanks

User avatar
Certified Developer v6
Certified Developer v6
kmurphy-wakefly - 6/18/2013 11:45:06 AM
   
RE:Error running upgrade from v6
I am having this same issue. I'd love to hear how this is fixed.

User avatar
Kentico Support
Kentico Support
kentico_radekm - 6/19/2013 3:26:09 AM
   
RE:Error running upgrade from v6
Hello.

Could you please check that all your tables in your database using the default "dbo." prefix? Is that so, or are there any which have different prefix or none? If so, changing default schema to “dbo” could help.

Also, could you please make sure the user which you are using in the connection string/connection to the database, has the correct schema and user assigned to it?

Thank you.

Best Regards,
Radek Macalik

User avatar
Member
Member
LordHits - 7/9/2013 11:59:49 AM
   
RE:Error running upgrade from v6
Make sure you are in the sysadmin role in the DB when running the upgrade process.

User avatar
Member
Member
bochen.lin-global-health - 8/8/2013 9:33:46 PM
   
RE:Error running upgrade from v6
I hit the same wall and your solution helped, thank you.