Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It allows you to not only move your schema and data, but also uncontained objects from your source server to your target server.
Basic recommendations based features
The DMA Azure SQL Database SKU advisor capability makes several recommendations based on the features and storage used for your application. Here are some examples of what it looks for and recommends.
- This Database has buffer pool enabled. This workload is more suited to the premium or business critical tier.
- This database is hosted on an HDD. It is more suited to the standard / general purpose tiers.
- This database is hosted on an SSD. It is more suited to the premium / business critical tiers.
- The database size is too large to fit into this tier.
- This server has HA enabled. This feature is not available in the standard / general purpose tiers.
- There is a less expensive SKU that can host the database.
- This database has Replication enabled. This workload is more suited to the standard / general purpose tiers.
- This database appears to have very light traffic. It will be most cost-effective to host it on the Standard Tier.
