Tools for Upgrade SQL Server 升級SQL Server的工具

Tools for Upgrade SQL Server

升級SQL Server的工具:

1.Data Migration Assistant
Microsoft Data Migration Assistant v5.2
https://www.microsoft.com/en-us/download/details.aspx?id=53595
System Requirements:
Supported Operating System
Windows Server 2016, Windows 10, Windows Server 2012, Windows 7, Windows 8, Windows 8.1
Windows 7 64-bit (or Windows Server 2012) and above
.NET Framework 4.7.2 64-bit or above

Supported source and target versions

• Source: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019 and, RDS SQL Server
• 
  
• Target: SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Azure SQL Database, Azure SQL Database Managed Instance

What's new in Data Migration Assistant
https://docs.microsoft.com/en-us/sql/dma/dma-whatsnew?view=sql-server-ver15
Data Migration Assistant v4.5開始支援SQL Server Integration Service (SSIS)

Upgrade SQL Server using the Data Migration Assistant
https://docs.microsoft.com/en-us/sql/dma/dma-migrateonpremsql?view=sql-server-ver15


2.SQL Server 2014 Upgrade Advisor
SQL Server 2014 Upgrade Advisor
https://docs.microsoft.com/en-us/sql/sql-server/install/sql-server-2014-upgrade-advisor?view=sql-server-2014

Upgrade Advisor supports remote analysis of all SQL Server components except Reporting Services.

• Upgrade Advisor does not analyze remote instances of Reporting Services. To analyze an instance of SSRS, Upgrade Advisor must be installed on the computer where SSRS is installed.
• To analyze SQL Server Integration Services, you must have the SQL Server Database Engine installed and Integration Services installed on the same computer.
• 
  
• Servers that are running SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 can be upgraded to SQL Server 2014. Whereas some SQL Server components can be upgraded in place, others must be migrated, and still others have been superseded by new components. For example, starting with SQL Server 2005, Integration Services (SSIS) supersedes Data Transformation Services (DTS), and DTS is no longer supported in SQL Server 2014. When you formulate your upgrade plan, you might need to plan for updating your current DTS packages to SSIS packages.

The prerequisites for installing and running Upgrade Advisor are as follows:

• Windows Vista SP1, Windows Server 2008 beginning with SP2, Windows 7, or Windows Server 2008 R2.
• Windows Installer 4.5. You can install Windows Installer from the Windows Installer Web site.
• The .NET Framework, beginning with .NET Framework 4. The .NET Framework is available on the SQL Server 2014 product media, and from the SDK, redistributable, and service pack download Web site.
  • To install the .NET Framework 4 from the SQL Server 2014 media, locate the root of the disk drive. Then double-click the \redist folder, double-click the DotNetFrameworks folder, and run dotNetFx40_Full_x86_x64.exe (for both 32-bit and 64-bit operating systems).
• The Microsoft SQL Server Transact-SQL ScriptDom is a prerequisite for installing SQL Server 2014 Upgrade Advisor, and is not installed by Upgrade Advisor Setup. The Setup requires you to download and install the MicrosoftSQL ServerTransact-SQL ScriptDom from the SQL Server 2014 Feature Pack.

Use the following steps to complete the upgrade:

1. Review Hardware and Software Requirements for Installing SQL Server 2014.
2. Back up data and system settings.
3. Run Upgrade Advisor.
   Upgrade Advisor does not modify your data or change settings on your computer.
4. Review the issues identified in the Upgrade Advisor report.
5. Resolve any blocking issues that would prevent you from upgrading to SQL Server 2014.
6. Resolve any other pre-upgrade issues.
7. Run Upgrade Advisor to verify that all known issues have been addressed.
8. Run SQL Server 2014 Setup.
9. Resolve any post-upgrade and migration issues.