Migrating WSS 3.0/ 2007 application to SharePoint 2010

Step 1:

Stop all services which are related to SharePoint in the WSS3.0 server

Start à Run, enter “services.msc” Command

Detaching Databases Using SQL Server 2005 Interface

1.                   Open SQL Server Management Studio and connect to your SQL Server 2005 in Database Engine mode.

2.                   Navigate through the browser tree to the appropriate database where your content resides.

3.                   Right click on the database, open the menu Tasks and select Detach.

4.                   A window will appear with the database listed. Confirm that the options Drop Connections and Keep Full Catalogs are selected and click OK.

5.    The database is now detached.

Moving the database data and log files
Now that you have successfully detached the databases, we need to move the physical files to their new home. Commonly these files are located in C:\Program Files\Microsoft SQL Server\MSSQL\Data\ directory. Locate the appropriate files; this would include an .mdf (the data file) and an .ldf (transaction logs) and move them to their new home. You can optionally store them in separate folders if you choose to do so.

Re-Attaching the databases
Now that the files have been moved, we will now re-attach the databases. 

Attaching Databases using SQL Server 2008 Interface

1.                   Open SQL Server 2008 Management Studio and connect to your SQL Server in Database Engine mode.

2.                   Right click on the folder Databases and select Attach.

3.    In the Attach Databases window, click on the button Add. This will open the Locate Databases window.

4.       Select the .mdf file of the recently moved database and select OK.

5.       Notice 2 entries are displayed in Database Details section of the Attach Databases window. Also notice that the entry for the Log file type has a message of Not Found. This is because it is still looking in the original directory. Click on the browse button in the Current File Path for the log file and select the appropriate file location in the window.

6.       Repeat steps 2 through 5 for each additional database to attach.

7.    Click OK when complete. Databases are now attached.

Step 2

Create one web application in SharePoint 2010

Step 3

Stsadm -o addcontentdb –url “http://gisshare04” -databasename “WSS_Content_XXXXXXXXX"

http://gisshare04 àapplication name

WSS_Content_XXXXXXXXX àdatabase name

Step 4:

Open web application

Select ----->Site actions à site settings à modify all setting à

Select ----->Title description and icon

Select -----> upgrade (3^rd option)

Step 5:

After Doing WSS 3.0/2007 application is migrated to SharePoint 2010