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 2013 - Suggested Content Browser Locations

By
In SharePoint Site collection, we can configure “Suggested Content Browser Locations” to access the directories easily. When we configure these locations, we can see them as drop down to the users when we select the content SharePoint. To view this link, we need to activate the publishing feature. We can configure suggested content browser location at site collection level. To configure suggested content browser locations, navigate to Site Settings, in the Site Collection Administration section, click on “Suggested Content Browser Locations” link. We can see the list. Click on new item to create new suggested location link. To check the suggested content browser location navigates to any page, edit the page. Select Insert option. In the Select Asset dialog, We can see the Suggested link drop down as shown the image below.
Post a Comment
Read more

Accordion "Left Navigation" (Quick Launch) for SharePoint 2013

By
For Expand/collapse "Left Navigation (Quick Launch) for sharepoint 2013 Copy the below code and paste in Master page jQuery(document).ready(function () {  /*set dynamic css logic*/  if($('#sideNavBox .menu-item.selected').length){   //propagates the selected class, up the three.   $('li.static').removeClass('selected');   $('#sideNavBox .menu-item.selected').parents('li.static').addClass('selected');   //collapses top siblings of selected branch   $('#sideNavBox .menu-item.selected').parents('li.static').last().siblings()    .find('> ul').hide();  }  else $('#sideNavBox .root.static > li.static > ul').hide();  /*set accordion effect*/  $('#sideNavBox .root.static > li.static').each(function(){   if($(this).find('ul').length){    $(this).addClass('father').click(function(){     if($(this).children('ul').css('display')...
1 comment
Read more