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

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

Modifying the second level navigation arrow image

By
Open your master page. Switch to Code View. Search for "TopNavigationMenu". This should take you to the global navigation (top nav) instance of AspMenu. Using Intellisense in the code view, or using the Properties pane, add the following property to the AspMenu tag: DynamicPopOutImageUrl="insert image URL/path here"So your code should look like: Runat="server" DataSourceID="topSiteMap" DynamicPopOutImageUrl="/images/myimage.gif" >
Post a Comment
Read more

SharePoint 2010 New Features

By
Since Microsoft announced SharePoint 2010, the community has been speculating what are the new features that might offer. New User Interface including Ribbon Web Edit Silverlight WebPart Rich Theming Multiple Browser Support Visio Services Business Connectivity Services SharePoint Workspace Rich Media Support Tagging any type of content/site Streamlined Central Administration SharePoint Best Practices Analyzer Usage Reporting and Logging Large List Resource Throttling Unattached Content Database Recovery Visual Upgrade Language Integrated (LINQ) for SharePoint Developer Dashboard Business Connectivity Services Client Object Model (OM)
Post a Comment
Read more