Database upgrade from SQL Server 2012 to 2016 using side-by-side approach
We are trying to upgrade our database server from SQL server 2012 to 2016 using the side-by-side approach. Currently we are using the CLM version 6.0.5. Following are the steps we performed as part of the database upgrade :
1. Installed a new instance of 2016 SQL Server(QA02) in the same DB server where existing 2012 SQL Server(QA01) is running.
2. Taken back up of the 2012 server data
3. Stopped all the application server and the QA01 DB instance services.
4. Restored the backup into the QA02 instance.
5. Restarted CLM application server ( As of now only the QA02 services are running in the database server)
Apart from the above steps, do i need to make any changes in the application teamserver.properties for the db connection properties ?
We have decided to go for the side-by-side because of potential data loss risk in the in-place upgrade methodology.
Please help us to understand this scenario.
One answer
You may want to stop the server and the DB before taking a backup (step#3 first, then #2).
If the DB connection string does not change (same server, same port, same user/pwd), then, no change is needed on the server.
Just a side note, based on CLM 6.0.5 system requirement, only SQLserver 2012 and 2014 are supported on v6.0.5. https://jazz.net/wiki/bin/view/Deployment/CLMSystemRequirements605. SQLserver 2016 is supported in CLM v6.0.6+