Edytuj

Udostępnij za pośrednictwem

Install SQL Server Management Studio versions side-by-side

  • Artykuł

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

You can install SQL Server Management Studio 21 Preview on a computer that has an earlier major version of SQL Server Management Studio (SSMS) already installed.

Before you install versions side-by-side, review the following conditions:

  • Suppose that you use SSMS 21 to open a solution that was created in SSMS 20 or an earlier version. You can later open and modify the solution again in the earlier version unless you implement features that are specific to SSMS 21.

  • Suppose that you use SSMS 21 to open a solution that was created in SSMS 20 or an earlier version. You might need to modify your projects and files to be compatible with SSMS 21.

  • If you uninstall a version of SSMS on a computer that has more than one version installed, the file associations for SSMS are removed for all versions.

  • SSMS doesn't automatically upgrade extensions, because not all extensions are compatible. You must reinstall any extensions.

Install different channels of the same major SSMS version side-by-side

Each installation of SQL Server Management Studio 21 must have a unique combination of major version and channel. For example, you can install SQL Server Management Studio 21 Preview alongside the generally available (GA) SQL Server Management Studio 21 Release, when it's available.

With SQL Server Management Studio 21 Preview and later versions, when you upgrade from one minor version of SSMS to the next, by default, the Visual Studio Installer updates your current installation to the latest version in that channel. For example, if Microsoft releases version 21.1 to the preview channel, the installer tries to replace your current installation of SSMS with this latest version on the same channel.

Manual installation

You can manually use another bootstrapper to install a new instance of SSMS, or you can select one of the options from the Visual Studio Installer's Available tab.

  1. To use another bootstrapper, you can download and run the bootstrapper file for SSMS, from either the installation article or the releases article, for the version that you want to install side-by-side with your existing version of SSMS.

  2. Using the installer's Available tab presumes that you already have another channel of SSMS installed. First find the Visual Studio Installer on your computer and launch it. After it updates itself, select the Available tab and install one of the offered products.

Then follow the steps to customize your installation. For more information, see Install SSMS.

Support or troubleshooting

Sometimes, things can go wrong. If your SSMS installation fails, see Troubleshoot installation and upgrade issues for SQL Server Management Studio 21 Preview for step-by-step guidance.

You can reference SQL user feedback for other known issues (filter on Tooling under Groups) and to provide feedback to the product team.

Related content