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
Caitlin,
We just went through this last week. We created a completely new SQL 2016 server(VM) with newer OS instead of upgrading the SQL 2008 server. I did a restore from the midnight backup and proceeded from that, putting the old server in read-only mode. But we were changing many things, including server naming convention, so there was no way to upgrade the old environment anyway. I don't have any experience on the side-by-side environment you're talking about.
Woodruff Arts Center