Showing results for 
Search instead for 
Did you mean: 

TMS Upgrade with Migration to new external database



Our client is running version 13.2 of TMS with TMSXE and TMS Agent. They are running this on Windows Server 2008 R2 64-bit with SQL Server 2008 32-bit. We would ultimately like to get them upgraded to TMS 14.6 and migrate the database to an external SQL Server 2012 instance. I'm trying to find the path of least resistance for this upgrade/migration.

Would it be the following?

  1. Back up TMS database
  2. Uninstall SQL Server 2008 32-bit
  3. Install SQL Server 2008 R2 64-bit
  4. Restore database
  5. Migrate from TMS Agent to TMSPE
  6. Upgrade TMS to 14.6
  7. Migrate databases to external SQL Server 2012
  8. Update TMS to point to external database?


Or could this be done by migrating the TMS 13.2 database to the external SQL Server 2012 instance and then install TMS 14.6 clean on a new server and point to it? 

Appreciate any advice and assistance.


You should migrate the database before or after you upgrade TMS, it's the same number of steps either way, so it's up to you in what order you want to do it.  Regarding your comment about installing TMS on a clean server, take the below things into consideration (taken from the TMS release notes and latest install guide):

  • The Complete/Custom choice has been removed to simplify the installation. The installer contains all necessary dialogs in one install path. This means you can no longer change the database location during an upgrade; if required this must be done using TMS Tools before upgrading.
  • SQL Server is no longer installed as part of the Cisco TMS install.
  • If there is not an SQL database present on the server when installing Cisco TMS, you will be prompted to install Microsoft SQL Server.

You'll need to install TMSPE 1.0 in order to migrate the TMS Agent data into TMSPE, then you can upgrade TMS and TMSPE to their latest releases.  Just be sure to check all the release notes and latest install guides for any gotchas as well knowing any changes in behavior for what you're upgrading/installing (such as what's already noted above with installing newer version of TMS).

Content for Community-Ad