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

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

1.Data Migration Assistant (新工具)

Microsoft® Data Migration Assistant v5.8
https://www.microsoft.com/en-us/download/details.aspx?id=53595

Supported Operating Systems

Windows Server 2016, Windows 10, Windows Server 2012, Windows 7, Windows 8, Windows 8.1, Windows Server 2019, Windows Server 2022

Windows 7 64-bit (or Windows Server 2012) and above

.NET Framework 4.8 64-bit or above

.NET 6 64-bit

Recommended resolution (1024x756)

What is new in V5.8?

• Upgraded DMA command line to .NET 6.
• Improved memory collector for SKU recommendation to fix an issue causing query timeouts and high CPU usage on the source instance.

What issues have been fixed in v5.8？

• Fixed accessibility bugs.

Documentation

• Overview of Data Migration Assistant | Microsoft Docs
• Identify the right Azure SQL Database SKU for your on-premises databases | Microsoft Docs

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, SQL Server 2022 and, Amazon RDS for SQL Server
• Target: SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, SQL Server 2022, 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, 2012, 2008 Upgrade Advisor (舊工具)

Microsoft SQL Server 2016 Feature Pack 不再提供Upgrade Advisor Tool，建議改用新工具DMA

Microsoft® SQL Server® 2014 SP2 Feature Pack

https://www.microsoft.com/en-US/download/details.aspx?id=53164

Microsoft® SQL Server® 2012 SP4 Feature Pack

https://www.microsoft.com/en-us/download/details.aspx?id=56041

Microsoft SQL Server 2008 Upgrade Advisor

https://www.microsoft.com/en-us/download/details.aspx?id=11455

=== 舊資訊 ===

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.