By default, the database was created as a local file database using SQL CE. WebMatix is now deprecated, but it allowed a developer to quickly create a web frontend and database backend. It was an ASP.Net Razr Web Pages site was originally created several years ago using WebMatrix. I was recently working with a customer that needed to migrate an old web site to Azure. To the a 18.x version is both supported and recommended.In this post, Premier Consultant Tim Omta explains how to migrate from SQL CE to SQL Azure. So even when working with older SQL Server versions, upgrading SQL Server Management Studio For this reason, it is highly recommended to use the newest version possible to take advantage of new features and more stability through code fixes that are being continually released. Regardless of the edition being used, SQL Server Management Studio only comes in one flavorĪnd boasts backwards compatibility with almost all features from versions 2008 to 2019, including SQL Azure support.

Left: Management Studio 17, Right: Management Studio 16 Version 18 iterates off of this and is based on the Visual Studio 2017 shell. Which bring a modernized user interface and icon set, much more stability, and faster Starting with version 17, SSMS releases are the first SSMS products to be based off of Visual Studio 2015+, The latest version of Management Studio will always be available at the Download SQL Server Management Studio (opens new window) page.

Visual studio 2017 sql server compact