I have an SQL server where there is the main install (MSSQLSERVER) using SQL Server 2019 and an instance install (Sage) using SQL Server 2016.
Sage CRM 2021 R1 was installed by a colleague on the Sage instance using SQL Server 2016. I have been asked by another colleague to move the install from the 2016 instance (Sage) to the 2019 instance (MSSQLSERVER).
Therefore, I plan to install Sage CRM on the 2019 instance (MSSQLSERVER). I don't have any issues or questions there.
My question relates to the database. Does anyone know if I can backup the database on the 2016 instance and restore it on the 2019 instance without first upgrading the 2016 instance to the 2019? My gut tells me that I need to do the upgrade on the 2016 version and database before I move it. However, there are other databases on that install and I don't know that the client wants to upgrade those databases from 2016 to 2019. Therefore, I need to move the CRM database from the 2016 install to the 2019 install. Is that possible without first upgrading the database from 2016 to 2019? I am unsure here.
Any assistance would be greatly appreciated!! Thank you!!