Događaji
M03 31 23 - M04 2 23
Najveći događaj učenja jezika SQL, platforme Fabric i platforme Power BI. 31. mart - 2. april Koristite kod FABINSIDER da uštedite 400 dolara.
Registrirajte se danasOvaj preglednik više nije podržan.
Nadogradite na Microsoft Edge da iskoristite najnovije osobine, sigurnosna ažuriranja i tehničku podršku.
Applies to:
SQL Server - Windows only
SQL Server supports upgrade from SQL Server 2008 (10.0.x) and later. This article documents support and behavior for upgrading SQL Server Management Tools and management components such as SQL Server Agent, Database Mail, Maintenance Plans, XPStar, and XPWeb.
Važno
For local installations, you must run SQL Server Setup as an administrator. If you run SQL Server Setup from a remote share, you must use a domain account that has read and execute permissions on the remote share.
Consider the following issues before you upgrade to SQL Server:
All TSX servers should be upgraded before the MSX server is upgraded. For more information about MSX/TSX in SQL Server, see Automated Administration Across an Enterprise.
All components in an instance of SQL Server must be upgraded at the same time. Version numbers of the Database Engine, Analysis Services, and Reporting Services components must be the same in an instance of SQL Server.
You can add components to an existing installation of SQL Server at the time that you upgrade to SQL Server. For more information, see Upgrade SQL Server 2016 Using the Installation Wizard (Setup).
SQL Server Client Tools, such as SQL Server Management Studio, SQL Server Profiler, the Database Engine Tuning Advisor, sqlcmd, and osql are not upgraded to SQL Server. Instead, Client Tools run side-by-side with tools from previous SQL Server versions. SQL Server supports importing settings from earlier versions of SQL Server Client Tools.
Authentication from SQL Server Agent to SQL Server will be updated from SQL Server Authentication to Windows Authentication during upgrade. SQL Server Authentication is not supported in SQL Server.
Data for jobs and alerts will be preserved during upgrade to SQL Server.
If SQLMail is being used in the instance to be upgraded, associated XPs will be supported and enabled after the upgrade. Otherwise, they will be off.
Database Mail, also known as SQLiMail, will be upgraded with the Database Engine component of SQL Server. By default, Database Mail will be off after upgrade. Any schema updates should be reconciled with an update script after upgrade.
Supported Version and Edition Upgrades
Backward Compatibility_deleted
Upgrade SQL Server Using the Installation Wizard (Setup)
Događaji
M03 31 23 - M04 2 23
Najveći događaj učenja jezika SQL, platforme Fabric i platforme Power BI. 31. mart - 2. april Koristite kod FABINSIDER da uštedite 400 dolara.
Registrirajte se danasObučavanje
Modul
Assess SQL Server databases for migration to Azure SQL - Training
Learn multiple assessment tools that facilitate the migration of databases to Azure, including the Azure SQL Migration extension for Azure Data Studio, Azure Migrate, and Data Migration Assistant.
Certifikacija
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Dokumentacija
Upgrade SQL Server - SQL Server
This article provides links to resources that contain upgrade information for instances of different versions of SQL Server.
Upgrade: Installation Wizard (Setup) - SQL Server
The SQL Server Installation Wizard provides a single feature tree for an in-place upgrade of SQL Server components to the latest version of SQL Server.
SQL Server 2022: Hardware & software requirements - SQL Server
A list of hardware, software, and operating system requirements for installing and running SQL Server 2022.