Post reply

Upgrade database version to management studio version

  • May 5, 2017 at 2:41 pm

    #337712

    I have a database that is showing as SQL Server 11.0.6248 which is SQL Server 2012 minus a few CU updates.
    This database is running on SQL Server 12.0.5546 which is SQL Server 2014 up to date at the time of writing this according to http://sqlserverbuilds.blogspot.com/

    This database was originally on a server 2012 server a while back and was exported and imported into this new server about a year ago.  

    I would like the database to run on the same version of SQL Server...how can I upgrade this database?  Is there an upgrade tool?  Do I have to export and import the database from itself into itself to get the conversion?

    Thanks for any help.

  • May 5, 2017 at 3:05 pm

    #1941390

    Databases don't really have a "version" as you've described it, you can find the version of the instance you are connected to like this:
    SELECT @@VERSION AS version

    Databases do have a compatibility level, that you can see in sys.databases view:
    SELECT name, compatibility_level FROM sys.databases

    how did you get the information showing the "database" as 11.0.6248 as compared to 12.0.5546?

  • May 5, 2017 at 5:44 pm

    #1941400

    Chris Harshman - Friday, May 5, 2017 3:05 PM

    how did you get the information showing the "database" as 11.0.6248 as compared to 12.0.5546?

    If I open up SQL Management Studio and go to Help and About...this shows version 12.0.5546.
    If I right click on my database and click on properties...it shows 11.0.6248

  • May 6, 2017 at 1:06 am

    #1941414

    SSMS version has nothing to do with the Instance version - they are 2 independent products.
    you could easily be using SSMS 2017 with a 2008 R2 database

    So from your screen print server instance "vaultserver\autodeskvault" is a 2012, build version 11.0.6248.0 and has not been upgraded to 2014 contrary to your expectations.

    Maybe another instance was upgraded and you are connecting to the wrong one?

  • May 8, 2017 at 6:33 am

    #1941572

    So what would the recommend processes be to upgrade this server instance from 2012 to 2014?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply