Asked by: Ticu Jaisimha
technology and computing databases

Should I upgrade to SQL Server 2017?

Last Updated: 3rd April, 2020

40
You should consider SQL Server 2017 if…
(Remember, there are no more Service Packs, just Cumulative Updates.) You want easier future upgrades – because starting with 2017, you can have a Distributed Availability Group with different versions of SQL Server in it.

Click to see full answer.

In this way, is SQL Server 2017 stable?

Yes, SQL Server 2017 is stable. But don't take my word for it, go try it for yourself. SQL Server 2017 Developer edition is free. Install and see for yourself it is stable enough for your needs.

Additionally, is SQL Server still relevant? Absolutely, SQL Server is extremely popular. I can also tell you that there is a really large lack of talented folks in the DBA/SQL Dev job market right now, so its a boon for job seekers. Many of the skills you will pick will be transferable from platform to platform.

In this regard, can you restore a SQL 2008 database to SQL 2017?

More Information. When it restores the SQLServer 2008 or SQL Server 2008 R2 database backup to SQL Server 2016 or 2017, SQL Server has toupgrade the internal version of the databases. One of the version upgrade steps was optimized to shorten the upgrade time.

What version is SQL Server 2017?

SQL Server 2017 cumulative update (CU) builds

Cumulative update name SQL Server product version Release date
CU7 14.0.3026.27 May 23, 2018
CU6 14.0.3025.34 April 17, 2018
CU5 14.0.3023.8 March 20, 2018
CU4 14.0.3022.28 February 20, 2018

Related Question Answers

Rym Fuschini

Professional

Camelia Voelkmann

Professional

What is SQL Server 2017 Developer?

Microsoft SQL Server
Developer(s) Microsoft
Initial release April 24, 1989, as SQL Server 1.0
Stable release SQL Server 2017 / October 2, 2017
Written in C, C++
Operating system Linux, Microsoft Windows Server, Microsoft Windows

Aurentina Achotegui

Professional

Why is SQL Server 2017?

First, SQL Server 2017 improves query performance in code containing multi-statement table valued functions by providing runtime cardinality estimates to the query optimizer, also known as “interleaved execution.” Next, batch mode processing is further strengthened, above the ability to adjust batch mode memory grants

Kaci Daam

Explainer

Is SQL Server 2019 stable?

Microsoft SQL Server 2019 New Features
There are many advancements made to SQL server 2017 to release the new version, which is SQL Server 2019 making it more efficient and stable.

Melquiades Ricaud

Explainer

Which SQL Server is best?

Best SQL servers and relational databases
  1. Microsoft SQL. Vendor: Microsoft. User Reviews: 1,332.
  2. MySQL. Vendor: Oracle. User Reviews: 884.
  3. Oracle Database 12c. Vendor: Oracle. User Reviews: 411.
  4. Amazon Relational Database Service (AWS RDS) Vendor: AWS. User Reviews: 164.
  5. PostgreSQL. Vendor: PostgreSQL. User Reviews: 302.

Sarfaraz Muhlhuber

Explainer

Who uses SQL Server?

We have found 162,865 companies that use Microsoft SQL Server. The companies using Microsoft SQL Server are most often found in United States and in the Computer Software industry.

Top Countries that use Microsoft SQL Server.
Country Number of companies
United States 70198
United Kingdom 11514
India 8776
Canada 6380

Manrique Krabbenhoeft

Pundit

What is the difference between SQL Server 2012 and 2014?

SQL Server 2012 vs 2014
* SQL Server 2012 supports upto 64 GB RAM, SQL Server 2014 supports 4 TB RAM. * SQL Server 2012 supports upto 4 replicas in AlwaysOn technology whereas SQL Server 2014 supports upto 8 replicas. * SQL Server 2012 mainstream support is ending in 2017 and SQL Server 2014 will be ending in 2019.

Shakeel Nyamin

Pundit

Which version of SQL Server do I need?

Summary
Version Most recent service pack
SQL Server 2014 SQL Server 2014 SP3 (12.0.6024.0 – October 2018)
SQL Server 2012 SQL Server 2012 SP4 (11.0.7001.0 – September 2017)
SQL Server 2008 R2 SQL Server 2008 R2 SP3 (10.50.6000.34 – September 2014) Note Latest and final release for this version

Livan Cedenilla

Pundit

How do I upgrade SQL Express to Standard 2017?

Upgrade Microsoft SQL Express to Microsoft SQL Standard or Higher
  1. Run the full version of SQL setup application.
  2. Select Maintenance > Edition Upgrade.
  3. Select the AutodeskVault instance and start the upgrade.
  4. After the upgrade is complete, apply the latest SQL service pack since this upgrade actually does not have on and it is not transferred from SQL Express.

Yared Ouillon

Pundit

Is SQL Server 2017 backwards compatible?

SQL Server 2017 is backwards compatible for the below SQL Server versions: SQL Server 2016 (130) SQL Server 2014 (120) SQL Server 2012 (110)

Quino Springindschmitten

Pundit

Can you restore a SQL 2008 database to SQL 2016?

The first step is to take a backup from the SQL Server 2008 database, copy it to a drive in the SQL Server 2016 instance, and restore the database. After it has been restored, we see the following output messages: Database 'test' running the upgrade step from version 851 to version 852.

Lidiia Auton

Teacher

How do I upgrade SQL?

To upgrade to a different edition of SQL Server
  1. Insert the SQL Server installation media.
  2. To upgrade an existing instance of SQL Server to a different edition, from the SQL Server Installation Center click Maintenance, and then select Edition Upgrade.
  3. If Setup support files are required, SQL Server Setup installs them.

Stelica Pinsky

Teacher

How do I restore data from one database to another in SQL Server?

Open SQL Server Management Studio. Right-click on the database name, then select "Tasks" > "Export data" from the object explorer. The SQL Server Import/Export wizard opens; click on "Next". Provide authentication and select the source from which you want to copy the data; click "Next".

Fujun Palao

Teacher

Can we install SQL Server 2017 on Windows 7?

SQL Server 2017 does not support Windows 7, you need at least Windows 8. See https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server.

Meixia Zurbrugg

Teacher

How do I restore a previous version of SQL?

Steps to Migrate SQL Server Database to Lower Version
  1. Launch Microsoft SQL Server Management Studio (SSMS) and Go to Object Explorer.
  2. Select the desired database and right-click on it.
  3. Click on Tasks and choose 'Generate Scripts'
  4. Generate and Publish Scripts wizard will be opened.

Xufen Boudet

Reviewer

How do I upgrade to SQL Server 2016?

The steps involved in an in-place upgrade are as follows:
  1. Verify that backups exist for all databases (user and system).
  2. Review the list of prerequisites for SQL Server 2016 and install whatever is needed.
  3. Run the SQL Server 2016 installation media.
  4. Perform your post-upgrade tasks.

Ariel Leton

Reviewer

How do I copy a database in SQL Server 2014?

The Copy Database wizard pages
Launch the Copy Database Wizard in SQL Server Management Studio from Object Explorer and expand Databases. Then right-click a database, point to Tasks, and then click Copy Database. If the Welcome to the Copy Database Wizard splash page appears, click Next.

Zoya Belser

Reviewer

Is SQL still relevant 2019?

Why does it matter in 2019? SQL has been around for nearly 50 years, but it is still relevant today. Data is behind almost every decision we make and an extremely valuable asset, which perhaps makes SQL one of the most important languages you can learn in your career.

Javad Essan

Reviewer

Is SQL outdated?

'SQL is outdated'. 'RDBMS can no longer meet businesses' data management needs'. 'New database technologies like NoSQL are the solution for today's enterprises'.