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 1614 posts 7260 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
Please Sign in or register to post replies

Write your reply to:

Draft