locked
Migrate TFS2010 to TFS2012 new hardware and SQLServer 2008 to SQLServer 2012? RRS feed

  • Question

  • Hi,

    I have a TFS2010 environment, 2 tier, with a SQLServer 2008 data tier.

    I would like to migrate to a new TFS2012 environment, on *new* hardware, with app tier and data tier on the same server.  (I am going single server as recommended by the ALM Rangers documentation, it only has to support a maximum of 20 users).

    I've read all the TFS2012 installation guides, administration guide, planning guide, and upgrade guidance.  However, I'm still struggling to see a clear picture of the steps involved.

    At a high level it all sounds straightforward: backup the SQLServer databases, restore to the new database, install TFS, run the upgrade wizard.  Sounds easy.  But is it!?

    As an added complication, I'm also upgrading the database from SQLServer 2008 on the old kit, to SQLServer 2012 on the new.

    Before I can progress I've got some questions around the backup/restore step (as you can tell from the questions I am not a SQLServer expert!): 

    1. I'm using the TFS Power tool to do my backups of the TFS databases on the old kit. Can I use the power tool to restore the data to the new server or do I have to do the restore manually through SQLServer Management Studio?

    2. Do I manually create the new empty databases on the new server and then restore into those, or start from a completely blank server with no databases and just restore into that?

    3. The old server had 3 Team Project Collections, but I only actually want to keep one.  Can I just restore the one collection I want to keep or is there stuff in the configuration database that will require ALL of the original project collections to be restored?

    4. A couple of the databases on the old kit have "2010" in the name for some reason.  Like "TFS2010Configuration" for the configuration database.  Can I take this opportunity to change the name of the database and datafiles to just be TFS_Configuration like it should be?  How would I go about that?

    5. The old kit had extra drives where the datafiles were located.  So the OS and SQLServer install were on the C drive and the datafiles were on the D drive.  But the new kit just has a C drive.  When I do the restore will it be looking for the same location on the D drive to restore the files to?  How do I get it to use the C drive instead?

    6. As mentioned above the old kit is SQLServer 2008 but the new is SQLServer 2012.  The documentation states that the versions of SQLServer need to be exactly the same.  So is it even possible to upgrade to a newer version of SQLServer while also migrating to a new version of TFS?

    Thanks for any help with this.  While the ALM Ranger documentation for TFS is great and very extensive, I'm still struggling with these details of exactly how to handle the data migration.

    Thanks!

    Friday, January 18, 2013 8:26 PM

Answers

  • Hi robinsonpr,

    Thanks for your post!

    1.If you want to use TFS Power Tools to restore your databases on a new server, you need to clear the Launch Team Foundation Server Configuration Tool check box on the "Success" page of the installation wizard for TFS. If you clear this check box, the binary files for TFS are copied to the new server but not configured. You want to cnfigure the new installation with part of the configuration data from the backup databases. On the new Server, install the Backup Plan Power Tool, which includes the wizard that you will use to continue the process of restoring data for Team Foundation Server. For more information, please refer to TFS Power Tools help documents: Restoring Data for Team Foundation Server(Start->All programs->Microsoft Team Foundation Server 2012 Power Tools->Power Tools Help). You can also refer to this blog: http://elhajj.wordpress.com/tfs-application-tier-will-use-different-hardware-than-its-using-right-now-rtm/

    2. No, you needn't, you just install all the SQL Server features that TFS requires on the server where you'll run TFS. For more information, pleaser refer to http://elhajj.wordpress.com/set-up-sql-server-for-tfs-rtm/

    3. For this, you can refer to http://social.msdn.microsoft.com/Forums/en-US/tfsadmin/thread/04bb28c7-7382-493e-b1c6-601470b9229c

    4. Based on my understanding, you can't, if you rename the database name, it will not be recognized.

    5. During the restore, on the SQL Server Instance page, you can point each database to the specific instance of SQL Server to which you want to restore the data. By default, these values will show the name of their previous location.  You are not needed to specify the driver.

    Tip: If you use the same names for the new computers, your clients will continue to work without configuration changes.

    6. For this scenario, please refer to http://blog.damianbrady.com.au/2012/06/03/upgrading-tfs2010-tfs2012-rc-done/

    Hopeit helps!

    Best Regards,


    Cathy Kong
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.


    Monday, January 21, 2013 8:07 AM
    Moderator

All replies

  • Hi robinsonpr,

    Thanks for your post!

    1.If you want to use TFS Power Tools to restore your databases on a new server, you need to clear the Launch Team Foundation Server Configuration Tool check box on the "Success" page of the installation wizard for TFS. If you clear this check box, the binary files for TFS are copied to the new server but not configured. You want to cnfigure the new installation with part of the configuration data from the backup databases. On the new Server, install the Backup Plan Power Tool, which includes the wizard that you will use to continue the process of restoring data for Team Foundation Server. For more information, please refer to TFS Power Tools help documents: Restoring Data for Team Foundation Server(Start->All programs->Microsoft Team Foundation Server 2012 Power Tools->Power Tools Help). You can also refer to this blog: http://elhajj.wordpress.com/tfs-application-tier-will-use-different-hardware-than-its-using-right-now-rtm/

    2. No, you needn't, you just install all the SQL Server features that TFS requires on the server where you'll run TFS. For more information, pleaser refer to http://elhajj.wordpress.com/set-up-sql-server-for-tfs-rtm/

    3. For this, you can refer to http://social.msdn.microsoft.com/Forums/en-US/tfsadmin/thread/04bb28c7-7382-493e-b1c6-601470b9229c

    4. Based on my understanding, you can't, if you rename the database name, it will not be recognized.

    5. During the restore, on the SQL Server Instance page, you can point each database to the specific instance of SQL Server to which you want to restore the data. By default, these values will show the name of their previous location.  You are not needed to specify the driver.

    Tip: If you use the same names for the new computers, your clients will continue to work without configuration changes.

    6. For this scenario, please refer to http://blog.damianbrady.com.au/2012/06/03/upgrading-tfs2010-tfs2012-rc-done/

    Hopeit helps!

    Best Regards,


    Cathy Kong
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.


    Monday, January 21, 2013 8:07 AM
    Moderator
  • Thanks Cathy, a great help!
    Friday, January 25, 2013 8:35 PM