Shulou(Shulou.com)05/31 Report--

This article will explain in detail what are the four main points about upgrading SQL Server 2014. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Upgrading is not easy, but there are some features worth taking the time to learn. Here are some tips on how to avoid escalation problems.

Upgrading a critical business SQL Server instance is not easy; it requires a thorough plan. Incomplete planning increases the likelihood of upgrade problems, which can affect or delay upgrades for SQL Server 2014. There are some considerations that can help avoid upgrade problems when planning an SQLServer 2014 upgrade.

Select upgrade strategy

Consider internal or parallel migration strategies in SQL Server upgrades. I * parallel migration strategy because it is less risky, even if it is more difficult. Internal migration is not easy to roll back after an upgrade. The main advantage of internal migration is that there is no need to worry about SQL Server security and other configurations, as they are synchronized before and after the upgrade. However, internal migration requires that all system and user databases be backed up during the upgrade. If SQL Server is running in a virtualized environment, you can directly perform a snapshot of the virtual machine and use it as a rollback method after the upgrade fails.

In a parallel upgrade, the new version of SQL Server exists at the same time as the old version after installation, on different instances of the same or different servers. This is similar to migrating a database from an existing SQL Server instance after a new database installation. For example, if you use this method to upgrade an existing SQL Server 2008 instance to SQL Server2014, you must install SQL Server2014, while the SQL Server 2008 instance is on a different instance or on a different server. The advantage of this approach is that you can perform similar tests on database functions. Also, the rollback process is simpler than an internal upgrade because the original server remains the same. The disadvantage of this approach is that you have to perform the same database migration process after the new instance is generated, and manually modify the configuration and security of the SQL Server instance. However, if you are upgrading to new hardware or merging multiple SQL Server instances, it is more appropriate to adopt a parallel upgrade strategy.

Understand compatibility and hardware requirements

Before upgrading SQL Server 2014, it is important to understand compatibility and hardware platform requirements. SQL Server 2014 has some installation requirements for operating systems and hardware platforms. Different versions of SQL Server 2014 have different requirements. For example, each version of SQLServer 2014 has different operating system requirements. You must install the operating system and a specified version of the service pack (SP) to meet the SQL Server installation requirements. The prescribed SP requirements refer to * requirements. The SQL Server 2014 installer checks that your computer meets the operating system and hardware requirements before allowing installation or upgrade. Be sure to check the hardware and software requirements for specific versions. For example, if you are upgrading from SQL Server 2005 to SQL Server2014, make sure that the hardware supports running SQL Server2014.

Next, you should analyze the SQL Server environment that you plan to upgrade to ensure that the environment supports upgrading the current version to the expected version of SQL Server 2014. For information about the upgrade support path from older versions of SQLServer to SQLServer 2014, as well as the upgrade versions supported by SQLServer 2014, see the SQLServer Books Online article: "supported upgrade versions."

Use Upgrade Advisor

No matter which SQL Server upgrade method you choose, you should ensure that the application will work properly after the upgrade. The SQL Server Upgrade Advisor tool can help you prepare for a SQL Server upgrade. UpgradeAdvisor can help identify key issues that may affect the upgrade, such as obsolete or stopped features, destructive modifications, and behavior modifications. The Upgrade Advisor installation file (sqlua.msi) is located in the redist folder of the SQL Server 2014 installation introduction, and can also be found in the SQL 2014Feature Pack download package.

Install Upgrade Advisor

You can install Upgrade Advisor by running the SQLUA.msi file of the SQL Server 2014 product media redist folder. If you have downloaded the SQLServer 2014 feature pack, you can double-click the self-extracting executable file, and it will prompt you to accept the license agreement and enter registration information after installation.

When you run Upgrade Advisor, a welcome interface is first displayed. On the welcome screen, you can view the UpgradeAdvisor document, launch the UpgradeAdvisor wizard and UpgradeAdvisor report browser.

Perform the following steps to start and run UpgradeAdvisor:

1. On the start menu, find all programs-Microsoft SQL Server 2014, and click SQL Server 2014 Upgrade Advisor.

two。 On the SQL Server 2014 Welcome interface, click Launch Upgrade Advisor Analysis Wizard, and then click Next.

3. Check the upgrade service you want to analyze, and then click Next (next). You should only select services that are already installed on your computer. If an uninstalled service is selected, Upgrade Advisor detects that the service is not installed and reports an error status.

4. In the report, the status with the word "Before" in the When to fix column must be corrected before continuing to upgrade SQL Server.

5. Enter an instance name. You can select an existing instance by entering an instance name or selecting an instance from the drop-down list.

6. Select the authentication type: Windows authentication or SQL Server authentication. If Windows authentication is selected, the currently logged in user is used as the authentication account.

7. Handle tips for the selected specific service. By default, SQL Server Upgrade Advisor checks all databases. In addition, you can analyze trace files and SQL batch files to help detect application compatibility issues. However, you must make sure that the trace file and batch file contain all the commands used by the application. If you choose to detect the SSIS package when upgrading, select the analysis server or the package stored in the package file. If you want to analyze these two services, you must run Upgrade Advisor twice.

8. Check and confirm the settings.

9. Click Run to start the analysis process.

10. At this point, UpgradeAdvisor runs, and a progress dialog window displays the progress of the analysis. The * dialog window displays the final analysis results, listing all warnings or error status that may affect the upgrade.

For more information about Upgrade Advisor, please refer to Microsoft's official materials.

The SQL Server upgrade process is similar to the SQL Server 2014 installation process. You can install and upgrade services contained in the same installation file. For example, you can upgrade an existing instance of the database engine, or you can install Analysis Services, IntegrationServices, and Reporting Services. See the Microsoft SQL Server UpgradeHow-to Topics web page for more information.

After the upgrade, monitor application performance and check the Windows and SQL Server error logs to make sure there are no problems. Also, you should rebuild all user database indexes, run sp_updatestats scripts, and perform update statistics on all internal and external tables.

In addition to these tasks, DBCC UPDATEUSAGE; is performed on all user databases, which corrects the page calculation and row count in the catalog view.

On the upgrade of SQL Server 2014 what are four points are shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.