You can upgrade from SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 (11.x), SQL Server 2014 (12.x), and SQL Server 2016 (13.x).

Upgrades from Earlier Versions to SQL Server 2017 (14.x)

SQL Server 2017 (14.x) supports upgrade from the following versions of SQL Server:

  • SQL Server 2008 SP4 or later
  • SQL Server 2008 R2 SP3 or later
  • SQL Server 2012 SP2 or later
  • SQL Server 2014 or later
  • SQL Server 2016 or later

Steps to Migrate Database From SQL Server 2008 Database to 2017

Users need to go through the following instructions to transfer the database from one SQL Server to the latest SQL Server. Let’s get started.

  1. To initiate the process, first, open SQL Server Management Studio using Object Explorer. After that, connect it to the Source Server.
  2. Next, right-click on the existing database, choose Tasks option. Now, select Generate Scripts option from the given list.
  3. As soon as you click on Generate Scripts option, a wizard appears on the screen. Click Next to continue the process.
  4. In the Generate and Publish Scripts Wizard, make sure that the Script entire database and all database objects option is selected. Once you have done with this, click the Next button.
  5. In the Set Scripting options of the wizard, perform the following task;
    • Choose the Save scripts to a specific location option.
    • You need to mention whether database objects and data will be devoted (scripted) to single or multiple files. Besides this, also specify path and encoding of the generated scripts.
    • Next, click on the Advanced option.
  6. In the Advanced Scripting Options window, follow the below steps;
    • You need to specify Schema and data under the Script for Server Version heading.
    • Set the below-mentioned value to be True:
    1. Script Logins
    2. Script Full-Text Indexes
    3. Script Triggers
  7. Next, click on the Next button.
  8. In the Summary step of the Generate and Publish Scripts wizard, click Next.
  9. On the next page, click Finish to execute the generated scripts against the older version of SQL.


Last modified: April 3, 2020



Write a Reply or Comment