Posts

Showing posts from March, 2014

Upgrade from CMS 6R2 to EPiServer 7 CMS and from EPiServer Community 4.1 to EPiServer Community 7

Image
There is a requirement before upgrading a Community site with separate databases (CMS6r2 and Community 4.1) to EPiServer 7 and Community 7 is to merge the Community database with the CMS database. This is an instruction of how to accomplish this in MS SQL Server 2008 R2.

1. Startup
In the SSMS, right-click the Community database that shall be merged with the CMS database and generate a script.
2. Choose Objects
Select  “Select specific database objects” and then select Tables, Views, Stored Procedures and User-Defined Functions but not all objects within those boxes.  Objects to choose:

Tables
tblEPiServerCommon*
tblEPiServerCommunity*

Views
vwEPiServerCommon*
vwEPiServerCommunity*

Stored Procedures
spEPiServerCommon*
spEPiServerCommunity*

User-Defined Functions fnEPiServerCommon* fnEPiServerCommunity*
3. Set Scripting Options Save the script to a specific location and save to a single file. Then press the “Advanced button”. 4. Advanced Scripting Options General: Set “Types of data t…