{"id":25855,"date":"2018-12-19T09:00:00","date_gmt":"2018-12-19T17:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=25855"},"modified":"2019-02-13T08:52:17","modified_gmt":"2019-02-13T16:52:17","slug":"ssms-18-0-public-preview-6-released","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/12\/19\/ssms-18-0-public-preview-6-released\/","title":{"rendered":"SSMS 18.0 Public Preview 6 released"},"content":{"rendered":"

We are very excited to announce the Public Preview 6 of SQL Server Management Studio (SSMS) 18.0. In the spirit of more frequent releases, Preview 6 brings another incremental update to SSMS 18.0. This release has new features and capabilities, several bug fixes across SQL Server Management Objects (SMO), intelliSense improvements in UI, etc.<\/p>\n

You can download SSMS 18.0 Public Preview 6<\/a> today and review more details in the Release Notes<\/a>.<\/p>\n

As your on-premise SQL Server 2008 and SQL Server 2008 R2 installations approach their end of life support, are you looking for ways to modernize your database environments by migrating to Azure? If so, consider the following:<\/p>\n

Typically, you first want to assess your on-premise databases to identify any potential SQL Server features and\/or compatibility issues that can impact database functionality after you move to the newer version of SQL Server, Azure SQL Database, or Azure SQL Database Managed Instance. Next, you should plan for any needed fixes that you will need to accommodate in your target Azure Database platform after migration, as recommended by the Data Migration Assistant (DMA), and then you are ready to migrate your databases to Azure.<\/p>\n

In Preview 6 of SQL Server Management Studio 18, in the Tools<\/strong> menu we have integrated our Data Migration Assistant<\/a> (DMA) tool and Azure Database Migration Service<\/a> (DMS) to provide quick and easy access to these assets to help accelerate your migrations to Azure.<\/p>\n

In addition to being able to launch DMA directly from the Tools menu in SSMS 18, you can also download and install DMA from the Download Center. After you start DMA, connect to your source SQL Server(s) and assess the databases that you intend to migrate to Azure. You can also select the \u201cMigrate SQL Server to Azure\u201d option to access comprehensive step-by-step tutorials that guide you through using DMS to migrate your database to Azure.<\/p>\n

SMSS improvements:<\/h2>\n