asked on Import older database into newer version of mssql server
Hi
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
BR
Carlos
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
BR
Carlos
DatabasesMicrosoft SQL Server
Last Comment
Scott Pletcher
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
As to 10 dbs in one instance, that should be no problem. I have ~1000 dbs in a dev/qa instance at our site!
ASKER
hi
thanks for all the answers, its really helping me grip this.
so when importing a database of an older version, sql manager will ask me to upgrade it or is an option i have to check in for it to do it?
thanks for all the answers, its really helping me grip this.
so when importing a database of an older version, sql manager will ask me to upgrade it or is an option i have to check in for it to do it?
SQL will automatically upgrade the db, you don't have any choices to make there. You're not allowed to choose anything different for updating the internal structures of the dbs.
Before you do that, check the databases, any larger databases or heavily used ones should go into their own instance. If you're throwing everything into the same instance make sure you split out the memory allocation correctly.
Realistically, you have 10 databases, I'd check each of those first to find the compatibility and then decide if you can move them over.
There is a wizard that will allow you to select specific options for what happens to the database on import. I'd discuss the best option with the suppliers of the 10 databases and then go with what they recommend.