You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-overview.md
+2Lines changed: 2 additions & 0 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -49,6 +49,8 @@ One of the key benefits of migrating your SQL Server databases to SQL Managed In
49
49
50
50
## Choose an appropriate target
51
51
52
+
You can use the [Azure SQL Migration extension for Azure Data Studio] to get right-sized Azure SQL Managed Instance recommendation. The extension collects performance data from your source SQL Server instance to provide right-sized recommendation that meets your workload's performance needs with minimal cost. To learn more, see [Get right-sized Azure recommendation for your on-premises SQL Server database(s)](../../../dms/ads-sku-recommend.md)
53
+
52
54
The following general guidelines can help you choose the right service tier and characteristics of SQL Managed Instance to help match your [performance baseline](sql-server-to-managed-instance-performance-baseline.md):
53
55
54
56
- Use the CPU usage baseline to provision a managed instance that matches the number of cores that your instance of SQL Server uses. It might be necessary to scale resources to match the [hardware generation characteristics](../../managed-instance/resource-limits.md#hardware-generation-characteristics).
Copy file name to clipboardExpand all lines: azure-sql/migration-guides/virtual-machines/sql-server-to-sql-on-azure-vm-individual-databases-guide.md
+3-3Lines changed: 3 additions & 3 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -65,7 +65,7 @@ Before migration, it is still a good practice to run an assessment of your SQL S
65
65
66
66
The [Azure SQL Migration extension for Azure Data Studio](../../../dms/migration-using-azure-data-studio.md) provides a seamless wizard based experience to assess, get Azure recommendations and migrate your SQL Server databases on-premises to SQL Server on Azure Virtual Machines. Besides, highlighting any migration blockers or warnings, the extension also includes an option for Azure recommendations to collect your databases' performance data to recommend a right-sized SQL Server on Azure Virtual Machines to meet the performance needs of your workload (with the least price).
67
67
68
-
To learn more about Azure recommendations, see [Get right-sized Azure recommendation for your on-premises SQL Server database(s)](https://docs.microsoft.com/en-us/azure/dms/ads-sku-recommend.md).
68
+
To learn more about Azure recommendations, see [Get right-sized Azure recommendation for your on-premises SQL Server database(s)](../../../dms/ads-sku-recommend.md).
69
69
70
70
> [!IMPORTANT]
71
71
>To assess databases using the Azure SQL Migration extension, ensure that the logins used to connect the source SQL Server are members of the sysadmin server role or have CONTROL SERVER permission.
@@ -83,7 +83,7 @@ During the assessment of user databases, use Data Migration Assistant to [import
83
83
84
84
#### Assessments at scale
85
85
86
-
If you have multiple servers that require a Data Migration Assistant assessment, you can automate the process by using scripts using one of the following options. To learn more about using scripting see [Migrate databases at scale using automation](../dms/migration-dms-powershell-cli.md).
86
+
If you have multiple servers that require a Data Migration Assistant assessment, you can automate the process by using scripts using one of the following options. To learn more about using scripting see [Migrate databases at scale using automation](../../../dms/migration-dms-powershell-cli.md).
@@ -108,7 +108,7 @@ The following sections provide steps for performing either a migration by using
108
108
109
109
### Migrate using the Azure SQL Migration extension for Azure Data Studio (minimal downtime)
110
110
111
-
To perform a minimal downtime migration using Azure Data Studio, follow the high level steps below. For a detailed step-by-step tutorial, see [Migrate SQL Server to SQL Server on Azure Virtual Machine online using Azure Data Studio](../dms/tutorial-sql-server-to-virtual-machine-online-ads.md):
111
+
To perform a minimal downtime migration using Azure Data Studio, follow the high level steps below. For a detailed step-by-step tutorial, see [Migrate SQL Server to SQL Server on Azure Virtual Machine online using Azure Data Studio](../../../dms/tutorial-sql-server-to-virtual-machine-online-ads.md):
112
112
113
113
1. Download and install [Azure Data Studio](/sql/azure-data-studio/download-azure-data-studio) and the [Azure SQL Migration extension](/sql/azure-data-studio/extensions/azure-sql-migration-extension).
114
114
1. Launch the Migrate to Azure SQL wizard in the extension in Azure Data Studio.
0 commit comments