SQL Serwer Management Studio (SSMS) Public Preview 6 Released.
In Preview 6 of SQL Serwer Management Studio 18, in the Narzędzia 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 pobierać and install DMA from the Pobierać Center. After you start DMA, connect to your source SQL Serwer(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
- Lazur SQL DB scripting
- Query data store
- Profiler
- Copy Database Wizard
For a full list of changes, please see theRelease 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.