Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Glen Peters 24 posts 115 karma points
    May 08, 2020 @ 22:27
    Glen Peters
    0

    Does Umbraco 7 support MS SQL Server 2019?

    I am administrating an Umbraco site that is running 7.5.13. Our DBA is talking about upgrading all our MS SQL Servers to 2019. As I understand it, 2019 deprecates the SQL data types of text, image, and ntext. Since Umbraco 7 requires those data types, then we are going to have an issue.

    Will I need to do the fairly involved migration to version 8?

    Copy Link
  • Nik 1625 posts 7295 karma points MVP 7x c-trib
    May 08, 2020 @ 22:57
    Nik
    0

    Hi Glen,

    I believe you should be okay, it would be worth spinning up a test site quickly to confirm.

    The ntext data type is used by Umbraco which is now flagged as depreciated, but I believe is still present in 2019 so you should be okay.

    Nik

    Copy Link
  • Dmitriy 168 posts 588 karma points
    May 09, 2020 @ 10:32
    Dmitriy
    0

    Yes for sure.

    I have a live Umbraco 7 website with SQL Server 2019, there is nothing to worry about.

    Anyway, I would like to reinstall the database to let SQL Server convert it by itself.

    Copy Link
  • christhanah274 1 post 71 karma points
    May 10, 2020 @ 02:24
    christhanah274
    0

    I have the same issue, thanks

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

    Continue discussion

Please Sign in or register to post replies