Skip to main content

Upgrade Sharepoint Site 2007-2010

By
First this is the Home page of one of the Web Application of the MOSS 2007 farm I am going to migrate. As you may notice, I took a standard site definition : the Collaboration Portal, with a few custom Web  Parts and features as customizations.










Open SQL Server management studio and locate the Database you want to migrate and display its properties pane

Set the Database Read Only to true



You will notice that the database icon will turn to gray











And that all the corresponding SharePoint site are now in read only mode













Then perform a back up of the Database, and move this back up on your SharePoint 2010 Data Base Server.



Then, open the SQL Server Management Studio of your SharePoint 2010 farm Database Server
















Detach the content database
















to drop the existing connections


then, re attach the same database



 You can now restore the database coming from the SharePoint 2007 farm











Do not forget to check the option: overwrite the existing database


















Database Changes:
1.Take Backup of the current content database of myrtb site(2007 site) from SQL Server.

2.In SQL Management Studio, create new DB and restore the content database, need to change an option in the "options" tab of the restore dialog to get it to work. (Overwrite db).


Site Changes:
1.Create a "New Web Application" in SP2010.

2.Remove Content Database of newly Created site.
•c:\program files\common files\microsoft shared\web server extentions\14\bin.
•stsadm -o deletecontentdb -url http://*** -databasename -databaseserver .

3.Now restore the DB to the created Web Application from STSADM
stsadm -o addcontentdb -url http://*** -databasename yourcontentdb -databaseserver yoursqlserver

Comments

Post a Comment

Popular posts from this blog

Sharepoint Interview questions

By
What is Microsoft Windows SharePoint Services? How is it related to Microsoft Office SharePoint Server 2007? Windows SharePoint Services is the solution that enables you to create Web sites for information sharing and document collaboration. Windows SharePoint Services -- a key piece of the information worker infrastructure delivered in Microsoft Windows Server 2003 -- provides additional functionality to the Microsoft Office system and other desktop applications, and it serves as a platform for application development. Office SharePoint Server 2007 builds on top of Windows SharePoint Services 3.0 to provide additional capabilities including collaboration, portal, search, enterprise content management, business process and forms, and business intelligence. What is Microsoft SharePoint Portal Server? SharePoint Portal Server is a portal server that connects people, teams, and knowledge across business processes. SharePoint Portal Server integrates information from various systems into o...
1 comment
Read more

SharePoint 2010 Branding: Change site actions and welcome menu arrows

By
Here's how you can do it. Hide the image and give our custom image element a background image. Look Like: .ms-viewselector-arrow {     background: transparent url('/PublishingImages/images/Arrow.png') no-repeat scroll 0 0;     height: 4px; /* height of the image */     width: 5px; /* width of the image */ } .ms-viewselector-arrow img {     display: none; }
1 comment
Read more

Lookup field does not showing values in sharepoint2013

By
SharePoint Custom Form Shows HTML as Text on Lookup Fields   When creating a custom display form on SharePoint Designer, the form displays the actual HTML instead of rendering the HTML on the lookup columns. For example, see the below image: For the lookup value issue, you need to slightly modify the XSLT of the particular field from designer and add the attribute disable-output-escaping="yes" to the field.
Post a Comment
Read more