SQL Server Management Studio (SSMS) Offentlig forhåndsvisning 6 Løslatt.
In Preview 6 of SQL Server Management Studio 18, i Tools Meny, 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.
I tillegg, vi har også flere feilrettinger i følgende områder:
- IntelliSense in SSMS editor
- SMO
- Azure 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 Offentlig forhåndsvisning 6 kan installeres side ved side med SSMS 17.x for testformål. Som en påminnelse, bruk av pre-GA-programvare i produksjonsmiljøer støttes ikke.