Upgrading MS-SQL Server 2008 to 2014, any preparation guidelines?

  • Questions
  • Upgrading MS-SQL Server 2008 to 2014, any preparation guidelines?
Question ID: 107482
0
0

We are upgrading our SQL-Server 2008 to SQL-Server 2014 in preparation for installing/upgrading to QC/ALM12.53.
Are there any guidelines for the database upgrade?

Do we need to do anything special with our existing databases, or do they just upgrade in MS-SQL-server automatically?

Marked as spam
Posted by (Questions: 185, Answers: 13)
Asked on March 2, 2017 4:09 pm
4 views
Answers (1)
0
Private answer

You really do not have anything special that needs to be done with respect to upgrading the databases in MS-SQL-server for use with QC/ALM.

If you upgrade-in-place SQL2008 to 2014, the DB's get ''upgraded'' as part of the installation.

If you do backup of the DBs to BAK files (as suggested by HP for QC/ALM), then restore into MSSQL2014, it upgrades them as it restores.

As for proper upgrade paths for MS-SQL-Server, see this MS doc:

https://technet.microsoft.com/en-us/library/ms143393(v=sql.120).aspx

Marked as spam
Posted by (Questions: 3, Answers: 466)
Answered on March 2, 2017 4:14 pm