Hi all,
We're wondering what your experience has been when upgrading SQL Server your database server. Have you upgraded in place or side-by-side on the same server? Have you created new VMs or use new servers for the install and then migrated everything over?
Our Test 'database server' has two instances of SQL server, one named and one default. The default is used for our Test environment and the named is used for our Staging environment. We plan to keep the same 'application server' when upgrading to v14 but are on the fence about installing SQL 2016 side-by-side or on a new VM. What do you think of installing SQL 2016 on a VM that also has SQL 2008?
What has been your experience?
Thanks,Houston Symphony
We're not there yet, but here's what I'm planning. Current servers are Win 2008R2/SQL 2008. We will move to all new vm's for v14. I'm going to upgrade my App Server first. Once that's done and working with existing stuff, we'll create new vm's for v14, Live and Test. All Win2016/SQL2016. We'll have 2 or 3 SQL test instances on the Test vm, as we do now. Or option to add another Test vm if that's necessary. The new live server will be a new vm running only the Live instance. My ideas are subject to change however!!
...Dave