upgrade of sql server

[steve_clarke]

We are currently on SQL Server 2012 and this will be upgraded to SQL Server 2014. I have backed up my SoftwarePlanner dbs and can restore them into SQL Server 2014. How do I configure QAComplete to use the SQL Server 2014 instance?

[CGangloff]

Hello Steve,

Thank you for your post. I will check with our Enterprise team for you, but we will need to know if you are going to upgrade your current SQL instance to 2014 or install a named instance of SQL 2014 on the same machine?

Thank you,
Christiane

[steve_clarke]

Hi Christiane,

I will be installing a new instance of SQL Server 2014 and then restoring the Software Planner databases (backed up from the current 2012 instance).

The issue I have is that I can't seem to find where I configure QAComplete to use the new instance. 

During the installation process, there is a section that allows you to do this, but the SQLUpdater .exe used in the installation doesn't seem to function independently

and I don't seem to be able to find an entry in any of the .ini configuration files that have any entries regarding the location of the Software Planner dbs.

Kind regards,

Steve.

[steve_clarke · Accepted solution]

Hi Steve, Please refer to the "Update Web Server Connection Strings on Application Server" and "Update 32-Bit DSN on Application Server" sections of the KB article: https://smartbear-cc.force.com/portal/KbArticleViewer?name=QAComplete-Database-Migration-Guide These changes are only QAC setting changes, which are required after DB migration. Regards, Natalie Borovykh SmartBear Customer Care