How to Migrate Bamboo’s Time Tracking and Management from SharePoint 2010 to 2013

Have you recently upgraded to SharePoint 2013 and seek to migrate a Bamboo product from 2010 to 2013? In this article, we'll walk you through the necessary steps to perform a migration of Bamboo's Time Tracking and Management (TTM) R1.6 from SharePoint 2010 to SharePoint 2013 using the database backup and restore.  Please note that these instructions pertain to servers that have a single WFE. If your server is multiple WFEs, check out the article Perform an In-Place Upgrade of Time Tracking and Management R1.6 from SharePoint 2010 to SharePoint 2013 in order to  migrate TTM R1.6 from SP2010 to SP2013.

Server SP2010: pwss2010, SQL 2008 R2 Express

Server SP2013: vngo15sql2, SQL 2008 R2 Express

For this post, I will be using port 81 on pwss2010.  Here is a snapshot of what this looks like on the Time Tracking and Management site on SP2010:

Please note: In the TTM 1.6 SP2010 site, if you use the absolute path in the tool pane of the Timesheets Entry Web Part for the data source, you should change them to a relative path before backing-up the content database.  If you do not do this, you will receive an error message in the tool pane after migration.

1.            To start, back up WSS_Content_81 of port 81 from SP2010 server (pwss2010):

WSS_Content_81 on C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBackup

Please note: You should update the name of your database from WSS_Content_81 to WSS_Content_Port81.

2.            Next, restore the database to your SP2013 server (vngo15sql2)

Select your source and destination and check the Restore checkbox and Overwrite the existing database:

Click OK. You should next receive the following confirmation message once the database has been successfully restored:

3.            Create a new Web application on your SP2013 server (vngo15sql2):

  • Create a new Web application with port 81

  • After the new web app has been successfully created, go to the Central Administration > Application Management > Manage content databases and remove the current database of the created web app:

4.            Add the restored content database to the new Web app (port 81):

Run cmd as an Administrator and go to C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions15BIN

Run the stsadm command line below:

stsadm -o addcontentdb -url http://vngo15sql2:81 -databasename WSS_Content_port81

The Cmd line will run to until it hits 100% completed.

You can now verify that the upgrade completed successfully by navigating back to Central Administration > Application Management > Manage content databases.  The page will now display the upgraded database under your designated Web application.

5.            Install Time Tracking and Management on Port 81

From here, you are able to build 2013 on the storefront to install in your server. Make sure when installing TTM you select Web application 81.

After the component has finished installing, click Next. Carefully review the summary log to make sure that the installation was successful. Once you have verified that everything has been installed correctly, click Close.

6.            Convert from classic-mode to claims-based authentication in SharePoint 2013

After these Web Parts have been successfully installed, you must be run a command to convert the claim for port 81. Check out Microsoft's article Migrate from classic-mode to claims-based authentication in SharePoint 2013 for more information.

To begin, select Run as administrator on the SharePoint 2013 Management Shell:

Run the following command line:

Convert-SPWebApplication -Identity "http:// vngo15sql2:81" -To Claims


7.            Upgrade your Site Collection (UI2013)

Go to http://vngo15sql2:81 > Site Settings > Site Collection Upgrade


8.            Upgrade Time Tracking and Management

After you have upgraded your site to SharePoint 2013, go to the Time Tracking and Management Control Panel and click the Upgrade button in the Manage application upgrades section:

Upon hitting Upgrade, Time Tracking and Management will be successfully migrated from SharePoint 2010 to SharePoint 2013.

Please note: If you are using Alert Plus for alerts and reminders, please follow the steps in the article HOWTO: Migrate Alert Plus From SharePoint 2010 To SharePoint 2013 for PM Central and Time Tracking and Management to update Alert Plus and ensure that it is compatible with your newly migrated Time Tracking and Management.

SharePoint

Applications

SharePoint apps are stand-alone applications that perform specific tasks on a SharePoint site. Apps can perform functions such as managing a discussion board or knowledge base, performing project management or time tracking tasks, or doing other workflow operations.

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials


Essentials Plus


Bamboo Premier


Project Management Suite


Knowledge Management Suite


External User Manager


SharePoint

Web Parts

Extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of Web Parts. Web Parts are the building blocks of pages on a SharePoint site that can be used to customize the user interface and content of a site page. 

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials


Essentials Plus


Bamboo Premier


Project Management Suite


Knowledge Management Suite


External User Manager


Office 365

Cloud Parts

Cloud Parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft Office 365. More than mere ports of existing software to the cloud, our Cloud Parts have been built from the ground up to take advantage of the best that the cloud has to offer.

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Cloud Parts Suite for O365/SP Onl.


Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!