November Happy Hour will be moved to Thursday December 5th.

upgrade db from 5101 to 5102

Vote:
 

I am getting this error:

 EPiServer 5.1.422.256 can only be used with database version 5102, current version is 5101. Make sure both database and assemblies are upgraded correctly

 

so how do I upgrade the database?

 

The issue arises as there are multiple developers working on a site which was built with 5.1.422.122 but I happen to have 256 installed. which is fine.. I got it to talk nice and it all works except it is not happy with the database. I don't need to sync the database back but I do need to regularly update it.. So is there a script I can run on the database to make it acceptable and become 5102? 

#21990
Jul 18, 2008 15:38
Vote:
 
Upgrade your site via EPiServer manager, it'll probably solve this issue.
#21991
Jul 18, 2008 16:14
Vote:
 

You find SQL script to manually update your database with SQL scripts. Upgrade scripts is located under C:\Program Files\EPiServer\Manager\Download\Upgrade, or wherever you installed EPiServer Manager, and the file is called 5_1_422_122to5_1_422_256_.sql (or something similar).

1. Take backup of your database
2. Open SQL Server Management Studio.
3. Open the sql script file.
4. Make sure the correct database is selected.
5. Execute the script

#21995
Edited, Jul 18, 2008 19:34
Vote:
 

I would recommend that you either install SP1 yourself and use that site with the database, or even better, get your fellow developers to upgrade the site to SP2. Otherwise you might end up with unpleasant surprises further down the track.

Normally when working on a site with multiple developers I would recommend developing against a shared database.

#22027
Jul 20, 2008 6:27
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.