locked
Migration from SQL server 2014 to SQL server 2017 RRS feed

  • Question

  • Hi All,

    We are planning to migrate to sql server 2017 from SQL server 2014 and we are using below approach

    1)Created a new SQL server environment with SQL server 2017 installed on it

    2)Restored the 2014 Sql server database to 2017 environment

    Restore was fine but wanted to check if its the recommended approach as the database is still of 2014 which we just restored to 2017.Will restore upgrade the 2014 database to 2017 version?

    Thanks

    Wednesday, April 1, 2020 4:07 PM

All replies

  • Hi Snehasis,

    >>>Will restore upgrade the 2014 database to 2017 version?
    yes, the restore will automatically upgrade the database version.

    In addition, migration from SQL server 2014 to SQL server 2017 , you also could use the tool: Microsoft Data Migration Assistant.

    Best Regards,
    Cris


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, April 2, 2020 4:37 AM
  • Thanks Chris Zhan,do i need to change the compatibility after restore to 140?
    Thursday, April 2, 2020 2:38 PM
  • Hi Snehasis,

    >>>do i need to change the compatibility after restore to 140?
    Yes, it is necessary to change the compatibility level of the database to SQL Server 2017 (140).
    Essentially, changing the compatibility level to a higher level considered to be a real upgrade.

    Before changing the compatibility level of the database, you should first understand the impact of this change on the application. refer to View or Change the Compatibility Level of a Database.

    Best Regards,
    Cris


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, April 3, 2020 1:39 AM