I want to confirm (as there are already some posts about it) that migration from SQL2005 to SQL2008 db does not require any reinstalls / actions on the application side.
- We have TMS 13.2.2 running with remote DB on SQL2005.
- Our DB team is migrating all DB to SQL 2008 (and SQL2012 - that is not supported by TMS)
- We want to confirm that IF DB team migrates our DB to 2008 (Proper migration with no changes to names etc) than TMS will continue to work with no intervention needed from TMS application. By intervention I mean no need to reinstall / install new packages on TMS.
I have seen post on SQL2005 to SQL2008 express migration - but the answer also included install of new TMS...
You won't have to uninstall and reinstall TMS, you just need to use the TMS Tools so has to point the TMS application to the new external SQL Server and instance where the TMS db (tmsng) will be found. And as usual, you'll need a user that as the appropriate access to the SQL and the TMS db (per TMS documentation - Install doc).