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
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.
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?