Jeremy Louder Define Version of SQL Server is Best For Developing Database

Jeremy Louder 0 Reputation points
2023-01-26T20:35:47.8066667+00:00

Jeremy Louder | I need To Develop Some Database in SQL Server 2012. I Might be Best SQL Server 2012 To Develop Database with Enhance Features.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,318 questions
{count} votes

5 answers

Sort by: Most helpful
  1. Jeremy Louder 0 Reputation points
    2023-01-26T20:36:31.08+00:00

    SQL server 2012 or SQL server 2016

    0 comments No comments

  2. Bruce (SqlWork.com) 52,826 Reputation points
    2023-01-26T21:01:53.8766667+00:00

    SQLServer 2012 is no longer supported. If for some reason its your target, then just use sqlserver 2012 developer edition. I believe you will need a visual studio subscription to get the download.

    If you just want to learn features, than the sqlserver 2022 developer edition is free.

    0 comments No comments

  3. Martin Cairney 2,241 Reputation points
    2023-01-27T01:59:33.25+00:00

    Rather than which version of SQL Server you use, you should be paying attention to the Database Compatibility Level that you set the database to.

    Since SQL Server 2016, switching on of new query engine functionality is done using the Database Compatibility Level. For example, if you develop a new database on SQL Server 2022, but set the DBCompat to 140 then in effect the database engine is behaving like SQL Server 2017 and the enhancements that became available since then won't necessarily be reflected in your database.

    I would always advise to develop on the latest platform version (currently SQL Server 2022) and then set the DBCompat for your database according to your target consumers and the versions of SQL Server that they may have, noting that you cannot set the DBCompat higher than the default level for that platform - i.e. the highest DBCompat on SQL Server 2019 is 150.

    Download the SQL Server 2022 Developer Edition for your new work and set your compatibility as needed for your application - but if no legacy compatibility is needed then set it to 160.


  4. Olaf Helper 39,181 Reputation points
    2023-01-27T07:03:02.61+00:00

    How do you define "the best"? If there would be "the best", then there would be only one ... the best.

    Use the latest version.

    SQL Server 2012 is old and already out-of-support, see

    https://learn.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2012

    0 comments No comments

  5. Seeya Xi-MSFT 16,416 Reputation points
    2023-01-27T07:29:01.7533333+00:00

    Hi Jeremy Louder,

    As they said, SQL Server 2012 is old and already out-of-support. Please refer to this document about Editions and supported features of SQL Server 2016

    You can see the other versions of SQL Server from the left navigation bar.

    Best regards,

    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments