Im upgrading from mssql 2012 to 2017. When i export from 2012 and import the databases into 2017, are they automatically upgraded to the new database engine or can i choose to upgrade? If its possible to not upgrade when importing (some programs do not support 2017) can i choose later to upgrade the database?
If its possible to run databases on different versions on the same server, is there any query where i can see the database version?
Im planning to move around 10 different databases into the same database instance