Deprecated Microsoft utility for evaluating SQL Server readiness and copying schema plus data into Azure SQL Database. Its assessment role has passed to Azure Arc-enabled SQL Server and to SSMS.
Also called DMA, DMA.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Data Migration Assistant in context, with comparison tables and the common traps.
Terms in this definition
- SQL Server
The relational database from Microsoft that organisations host and run themselves, in their own data centres or on VMs. Its engine also sits underneath the Azure SQL services and SQL database in Fabric.
- Schema
The middle part of a Unity Catalog name (
catalog.schema.table), grouping tables, views, volumes, functions and models inside a catalog. A grant on it covers everything in it now and later, and nothing inside can be reached withoutUSE SCHEMA. - Azure SQL Database
Platform-as-a-service database offered as a single database or in an elastic pool, sized up to 4 TB or 128 TB on Hyperscale. SQL Agent, CLR and queries across databases aren't available.
- Role
How an actor normally or expectedly behaves, or the part a person takes in a process. A single actor may hold more than one role.
- SSMS
SQL Server Management Studio, a tool for administering SQL Server, used for tasks such as building a target schema.