Key takeaways from the ebook "Migrating SQL Server to Azure SQL Database Managed Instance"
The ebook "Migrating SQL Server to Azure SQL Database Managed Instance" [PDF] provides a quick summary of Azure SQL Database Managed Instance features & steps to migrate to it.
Key points from the ebook -
Data Migration Assistant reviews the target migration environment and surfaces new features that will benefit your data post-migration. It checks for database compatibility and feature parity
The Azure Database Migration Guide can help you plan your migrations and provide information about migration tools that are available. Input your source and target platform choices into the guide, and it will create a customized playbook to suit your individual scenario
Azure Database Migration Service is a fully managed migration service designed to enable seamless migrations from multiple database sources to Azure data platforms with minimal downtime
Restore of system databases is not supported. To migrate instance-level objects (stored in master or msdb databases), Microsoft recommends that you script them out and run T-SQL scripts on the destination instance.
Native RESTORE from URL is an alternative to using Database Migration Service for migration to Azure SQL Database Managed Instance.
Azure SQL Database Managed Instance performs backups for you automatically. You can restore to any point in time within the retention period using Point in Time Restore (PITR).
Database Migration Service does not yet support migrating SQL Server Integration Services (SSIS), SQL Server Analysis Services, or SQL Server Reporting Services (SSRS) components from SQL Server on-premises environments.
For migrating SSIS, you can provision Azure-SSIS integration runtime (IR) in Azure Data Factory.
For SQL Server Analysis Services, you can migrate to Azure Analysis Services.
SSRS currently has no cloud-based equivalent, but you can rewrite reports by using Microsoft Power BI or migrate reports to SSRS on an Azure virtual machine.
Key points from the ebook -
Data Migration Assistant reviews the target migration environment and surfaces new features that will benefit your data post-migration. It checks for database compatibility and feature parity
The Azure Database Migration Guide can help you plan your migrations and provide information about migration tools that are available. Input your source and target platform choices into the guide, and it will create a customized playbook to suit your individual scenario
Azure Database Migration Service is a fully managed migration service designed to enable seamless migrations from multiple database sources to Azure data platforms with minimal downtime
Figure 2: How Azure Database Migration Service works
Restore of system databases is not supported. To migrate instance-level objects (stored in master or msdb databases), Microsoft recommends that you script them out and run T-SQL scripts on the destination instance.
Native RESTORE from URL is an alternative to using Database Migration Service for migration to Azure SQL Database Managed Instance.
Azure SQL Database Managed Instance performs backups for you automatically. You can restore to any point in time within the retention period using Point in Time Restore (PITR).
For migrating SSIS, you can provision Azure-SSIS integration runtime (IR) in Azure Data Factory.
For SQL Server Analysis Services, you can migrate to Azure Analysis Services.
SSRS currently has no cloud-based equivalent, but you can rewrite reports by using Microsoft Power BI or migrate reports to SSRS on an Azure virtual machine.
Azure SQL Database Managed Instance offers the following security features -
- Encryption for data in motion via Transport Layer Security, which also provides protection for sensitive data in flight, at rest, and during query processing via Always Encrypted.
- Dynamic Data Masking to limit exposure to sensitive data by masking it from non-privileged users and helping to prevent unauthorized access to it.
- Row-Level Security (RLS) helps you to control access to rows in a database table based on the characteristics of the user executing a query.
- Encryption for data in motion via Transport Layer Security, which also provides protection for sensitive data in flight, at rest, and during query processing via Always Encrypted.
- Dynamic Data Masking to limit exposure to sensitive data by masking it from non-privileged users and helping to prevent unauthorized access to it.
- Row-Level Security (RLS) helps you to control access to rows in a database table based on the characteristics of the user executing a query.
- Azure SQL Database Threat Detection detects anomalous activities, flagging unusual or potentially harmful breaches.
- Database-level authentication via Azure Active Directory to centrally manage database users and simplify permission management.
- Monitoring of database activities via auditing and threat detection
- Database-level authentication via Azure Active Directory to centrally manage database users and simplify permission management.
- Monitoring of database activities via auditing and threat detection
Comments
Post a Comment