Link to home
Start Free TrialLog in
Avatar of carlos soto
carlos sotoFlag for Sweden

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
Avatar of Alex
Alex
Flag of United Kingdom of Great Britain and Northern Ireland image

10 different databases into the same database instance

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.
SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

As to 10 dbs in one instance, that should be no problem.  I have ~1000 dbs in a dev/qa instance at our site!

Avatar of carlos soto

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?

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.