Public preview: Schema migration for target Azure SQL DB

Azure Updates

Discussionpowered by zap.ms

Published

Nov 22, 2023

Status

In preview

Timeline

  • November 2023
    Preview

Product

Azure Database Migration Service

Tag

Features

Category

Databases
Migration

Description

Now, you can use Azure Database Migration Services (DMS) to perform schema migration while migrating to Azure SQL DB from the Azure Portal.
While configuring the SQL migration, if schema migration is enabled, it will allow you to migrate schema objects like schemas, tables, stored procedures, indexes, views, synonyms, DDL triggers etc. to target Azure SQL DB with the data migration. For schema migration to work, you must have SHIR version 5.34 and above installed and registered with DMS services. Currently it is available in DMS via the Azure Portal.

Learn More:
DMS overview
Schema migration