Događaji
M03 31 23 - M04 2 23
Najveći događaj učenja jezika SQL, platforme Fabric i platforme Power BI. 31. mart - 2. april Koristite kod FABINSIDER da uštedite 400 dolara.
Registrirajte se danasOvaj preglednik više nije podržan.
Nadogradite na Microsoft Edge da iskoristite najnovije osobine, sigurnosna ažuriranja i tehničku podršku.
Važno
Data Migration Assistant (DMA) is deprecated. For migration options from SQL Server to Azure SQL, see the migration options for SQL Server to Azure SQL.
The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can affect database functionality when you:
DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.
For SQL Server large migrations (in terms of number and size of databases) to Azure, we recommend that you use the Azure Database Migration Service, which can migrate databases at scale.
DMA doesn't support database migrations to Azure SQL Managed Instance. Use the Azure SQL Migration extension for Azure Data Studio instead, which supports both online and offline database migrations to Azure SQL Managed Instance.
To install DMA, download the latest version of the tool from the Microsoft Download Center, and then run the DataMigrationAssistant.msi
file.
DMA brings you the following capabilities:
Assess on-premises SQL Server instances migrating to Azure SQL Database or Azure SQL Managed Instance. The assessment workflow helps you to detect the following issues, which might affect your Azure SQL migration and provides detailed guidance on how to resolve them.
Migration blocking issues: Discovers the compatibility issues that block migrating on-premises SQL Server database to Azure SQL Database or Azure SQL Managed Instance. DMA provides recommendations to help you address those issues.
Partially supported or unsupported features: Detects partially supported or unsupported features that are currently in use by the source SQL Server instance. DMA provides a comprehensive set of recommendations, alternative approaches available in Azure, and mitigating steps so that you can incorporate them into your migration projects.
Discover issues that can affect an upgrade to an on-premises SQL Server. These are described as compatibility issues and are organized in the following categories:
Discover new features in the target SQL Server platform that the database can benefit from after an upgrade. These are described as feature recommendations and are organized in the following categories:
Migrate an on-premises SQL Server instance to a modern SQL Server instance hosted on-premises or on an Azure virtual machine (VM) that is accessible from your on-premises network. The Azure VM can be accessed using VPN or other technologies. The migration workflow helps you to migrate the following components:
Assess on-premises SQL Server Integration Services (SSIS) packages migrating to Azure SQL Database or Azure SQL Managed Instance. The assessment helps to discover issues that can affect the migration. These are described as compatibility issues and are organized in the following categories:
Migration blockers: discovers the compatibility issues that block migrating source packages to Azure. DMA provides recommendations to help you address those issues.
Information issues: detects partially supported or deprecated features that are used in source packages.
After a successful migration, applications can connect to the target SQL databases seamlessly.
To run an assessment, you have to be a member of the SQL Server sysadmin role. The recommended display resolution is 1024x756.
DMA replaces all previous versions of SQL Server Upgrade Advisor and should be used for upgrades for most SQL Server versions. The following list shows the supported source and target versions for assessment:
Supported sources
Supported targets
Događaji
M03 31 23 - M04 2 23
Najveći događaj učenja jezika SQL, platforme Fabric i platforme Power BI. 31. mart - 2. april Koristite kod FABINSIDER da uštedite 400 dolara.
Registrirajte se danasObučavanje
Modul
Assess SQL Server databases for migration to Azure SQL - Training
Learn multiple assessment tools that facilitate the migration of databases to Azure, including the Azure SQL Migration extension for Azure Data Studio, Azure Migrate, and Data Migration Assistant.
Certifikacija
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Dokumentacija
Perform a SQL Server migration assessment - Data Migration Assistant
Learn how to use Data Migration Assistant to assess an on-premises SQL Server before migrating to another SQL Server or to Azure SQL Database
Compare SQL data migration tools - SQL Server
Compare SQL data migration tools to determine which tool best suits your business needs, such as Data Migration Assistant (DMA), Azure Migrate, Azure Database Migration Service, SQL Server Migration Assistant (SSMA), Database Experimentation Assistant (DEA).
Configure settings for Data Migration Assistant - SQL Server
Learn how to configure settings for the Data Migration Assistant by updating values in the configuration file