SQL Server Management Studio (SSMS) Public Preview 6 Released.
In Preview 6 of SQL Server Management Studio 18, in the Tools menu, Microsoft has integrated Data Migration Assistant (DMA) tool and Azure Database Migration Service (DMS) to provide quick and easy access to these assets to help accelerate your migrations to Azure.
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 “Migrate SQL Server to Azure” option to access comprehensive step-by-step tutorials that guide you through using DMS to migrate your database to Azure.
SMSS improvements:
- SSMS – Added logic to prompt the user to commit open transactions when “Change connection” is used.
In addition, we also have several bug fixes in the following areas:
- IntelliSense in SSMS editor
- SMO
- Azure SQL DB scripting
- Query data store
- Profiler
- Copy Database Wizard
For a full list of changes, please see the Release Notes.
If you have a previous version of SSMS 18.0 preview, you will need to uninstall it first. SSMS 18.0 Public Preview 6 can be installed side-by-side with SSMS 17.x for testing purposes. As a reminder, the use of pre-GA software in production environments is not supported.