Avatar of Jerry Seinfield
Jerry Seinfield
 asked on

SQL 2019 downgrade

Hello SQL Experts,


Can I purchase SQL 2019 and downgrade to 2016? 

The reason for that is because we do have an application that is supported only by the 2016 version.


If so, is there a downtime when tables are indexed during maintenance?

How much would assurance cost?


Microsoft SQL Server

Avatar of undefined
Last Comment
DEMAN-BARCELO (MVP) Thierry

8/22/2022 - Mon
Éric Moreau

have you tried setting the compatibility level to 2016. In most cases, it is working as good.
Scott Pletcher

Previously it's been my experience that if you license the current version of SQL, you can install an earlier version instead if you prefer.  But check with whomever you're licensing the SQL from to be sure.  Check with them too on assurance cost.  

The other q, "is there a downtime when tables are indexed during maintenance", is a totally different subject.  Generally yes, but it could depend on the specific edition of SQL you licensed (Enterprise has many more tools for avoiding down time while doing maintenance.)


ASKER CERTIFIED SOLUTION
ste5an

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
DEMAN-BARCELO (MVP) Thierry

Hello,

note also that you can have several versions of SQL used by different instances of SQL:

https://docs.microsoft.com/en-us/sql/sql-server/install/work-with-multiple-versions-and-instances-of-sql-server?view=sql-server-ver15

So the Admin interface can be SQL 2019, and one of the instance running with SQL 2016.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy