Share Point Database Details and Upgrade Share Point 2010 to 2013

Description: Here I have explained Share Point database details and how to upgrade Share Point from 2010 to 2013

Share Point Databases:

·         1 Database for SharePoint Configuration (SharePoint_Config_{Guid})

·         1 Database for SharePoint Central Administration (SharePoint_AdminContent_{Guid})

·         If you have 3 web applications, you will have minimum 3 SharePoint Content Databases. Each will have 1 SharePoint Content Database.

·         The Content database was named like WSS_Content_{GUID of webapplication}

SharePoint upgradation process from 2010 to 2013:

1>     Set up Server 2012 Server and a SharePoint 2013 Farm in Target server

-          Set up Server 2012 and install SharePoint 2013 on the target server and configure a SharePoint 2013 farm. When you create your Web application and site collection, make sure that you create the same type of site, the same port and the same authentication method as the source site.

2>     Copy the SharePoint 2010 Database to the Target Server

-          Before proceeding, please make a backup of your Source Server's SharePoint application.

-          Next, open SharePoint Central Administration on the source server and navigate to Application Management > Manage Content Databases. Locate the database pertaining to your Web application.

-          Copy database [wss_content_database] or relevant SharePoint database to new database server.

-          Check db_owner privilege must be assigned to user.

-          From SharePoint 2013 [Target server] management shell run below command

Mount-SPContentDatabase -Name WSS_Content -WebApplication http://taurus/

3>     Verify site after migration

-          Enter your site and verify that it's working. You may notice that it still looks like SharePoint 2012. That's because we have not yet upgraded the site collection.

-          Once you verify that the site is working, go to Central Administration > Application Management > Configure Alternate Access Mappings and change the default URL to the live URL of your Web site; alternatively, you can extend your Web site.

-          Once you make the port forwarding and/or DNS changes (if necessary), your newly migrated site will be live!

4>     Upgrade the Site Collection

-          The final step is to upgrade the site collection. Before proceeding with the site collection upgrade, create a backup or a snapshot of the SharePoint 2013 server in case the fecal matter impacts the therm antidote.

-          From the Web site, click site actions > site settings. In the site collection administration menu, click on the site collection upgrade link.