none
SQL server on linux updates databases to version 860, which is incompatible with SQL Server 2014

    Question

  • When attaching a database on SQL Server for Linux the database is automatically updated to version 860.  I've then detached the database and tried mounting it on a Windows server running SQL Server 2014 (12.0.4100.1).  This fails with the following error:

    The database 'SSA' cannot be opened because it is version 860. This server supports version 782 and earlier. A downgrade path is not supported.

    Is there an update to SQL Server 2014 tha makes it compatible with the latest SQL Server for Linux (14.0.100.187-1)?  If not, which versions of SQL Server for Windows are compatible with the SQL Server for Linux?  Is an upgrade to SQL Server 2016 necessary for cross compatibility of databases?

    Friday, January 20, 2017 2:40 PM

All replies

  • Hello,

    SQL Server on Linux is SQL Server Version vNext in preview state and vNext means the Version coming next after SQL Server 2016. You can not attach that database to any former released version.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Ekrem Önsoy Monday, January 23, 2017 6:09 AM
    Friday, January 20, 2017 3:01 PM
  • Hi Astro,

    >>Is there an update to SQL Server 2014 that makes it compatible with the latest SQL Server for Linux (14.0.100.187-1)?  

    No. Please note that once you attached a database(from lower version) to a higher version of SQL Server, you cannot attach it back as the internal database version has been updated and there’s no way to change it back.

    >>If not, which versions of SQL Server for Windows are compatible with the SQL Server for Linux?  

    SQL Server VNext for windows should work.

    >>Is an upgrade to SQL Server 2016 necessary for cross compatibility of databases?

    No, VNext is newer than SQL Server 2016.

    If you have any other questions, please let me know.

    Regards,
    Lin

    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.

    • Proposed as answer by Ekrem Önsoy Monday, January 23, 2017 6:09 AM
    Monday, January 23, 2017 2:55 AM
    Moderator
  • Thanks, good to know!

    We use a large number of databases that get cross-mounted on different servers simultaneously, so it looks like we'll need to wait on using SQL Server for Linux until the next official release for Windows is available.

    Tuesday, January 24, 2017 11:42 AM
  • The Windows version of VNext is also available:

    https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-vnext-ctp

    Both the Windows and Linux versions of SQL Server VNext are in preview, and shouldn't be used for production workloads.

    David


    Microsoft Technology Center - Dallas

    My Blog

    Tuesday, January 24, 2017 12:29 PM