Microsoft recently released a new version of SQL Server Management Studio called version 17.6. SQL Server Management Studio 17.x is the latest generation of SQL Server Management Studio and provides support for SQL Server 2017.
SSMS versions 16.x or earlier are not upgrade able to SSMS 17.x. Instead, SSMS 17.x installs side by side with previous versions. However, you can upgrade from 17.x (17.1, 17.2, 17.3 etc) to 17.6.
To avoid confusion, it is recommended that you should keep only one version of SQL Server Management Studio.
SSMS 17.6 which is labeled as “Microsoft SQL Server Management Studio 17” has a new icon and it can be easily distinguished if installed side by side with any other version.
In addition to enhancements and bug fixes, SSMS 17.6 comes with several new features such as:
- Added more support for Azure SQL Database Managed Instance.
- Fixed a key performance issue in SMO where scripting tables on SQL Server 2016 took 30 seconds, but now take less than one second.
- Object Explorer: Added settings to allow users not to force brackets around names when dragging and dropping from Object Explorer to Query Window.
- Data Classification: Improvements and bug fixes.