web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Upgrade SQL 2005 EXPRE...
Small and medium business | Business Central, N...
Answered

Upgrade SQL 2005 EXPRESS TO SQL EXPRESS 2014

(0) ShareShare
ReportReport
Posted on by seminolebs 80

I would really like to know how to upgrade SQL Server 2005 Express to SQL Server 2014 Express and install Management Studio if possible.

I have never been successful downloading and managing to upgrade the 2005 database to the 2014 structure. Can some one guide me

I have the same question (0)
  • ToddB Profile Picture
    ToddB on at
    RE: Upgrade SQL 2005 EXPRESS TO SQL EXPRESS 2014

    Hi Seminolebs,

    NOTE: Before performing any upgrade, etc. to SQL, it is recommended to make a backup of all databases as needed.

    In testing, I installed SQL Server 2014 without issue using the below steps:

    1. Clicked Download on the SQL Server 2014 Express page.

    Download Microsoft® SQL Server® 2014 Express from Official Microsoft Download Center

    2. Selected 'ExpressAdv 32BIT\SQLEXPRADV_x86+ENU.exe':

    pastedimage1620221983365v3.png

    3. Selected Upgrade:

    pastedimage1620221681097v2.png

    4. Selected the instance to upgrade:

    pastedimage1620222141102v4.png

    5. Upgrade installed without issue:

    pastedimage1620222782573v5.png

    Once SQL Server was upgraded, I validated I was able to log into Store Operations Manager and POS.


  • seminolebs Profile Picture
    seminolebs 80 on at
    RE: Upgrade SQL 2005 EXPRESS TO SQL EXPRESS 2014

    When I follow the steps to upgrade a 2005 instance MSSQLEXPRESS to 2014, I get the following rule check error:

    User database compatibility level equal or less than 90 check generated warning

  • ToddB Profile Picture
    ToddB on at
    RE: Upgrade SQL 2005 EXPRESS TO SQL EXPRESS 2014

    Hi seminolebs,

    Are you able to bypass the warning?

    What is the Compatibility Level if you look at the Properties of the database?

    pastedimage1622570289927v1.png



    View or Change the Compatibility Level of a Database - SQL Server | Microsoft Docs

    SQL Server 2014 does not support Compatability Level 90:

    ALTER DATABASE Compatibility Level (Transact-SQL) - SQL Server | Microsoft Docs

    pastedimage1622570895466v2.png

  • mcons Profile Picture
    mcons 390 on at
    RE: Upgrade SQL 2005 EXPRESS TO SQL EXPRESS 2014

    If that doesn't work, you could also try installing SQL 2008, restore to that, then use 2008 manager to do a backup and then install sql 2014 and that should restore.   

  • Verified answer
    POS Business Solutions Profile Picture
    POS Business Solutions 92 on at
    RE: Upgrade SQL 2005 EXPRESS TO SQL EXPRESS 2014

    Try to use old backup and updated

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,232

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,863

#3
Sumit Singh Profile Picture

Sumit Singh 2,819

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans