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
|`/ImportFeatureDiscoveryReportJson` | Path to the feature discovery JSON report created earlier. Instead of source connections, this file will be used. | N
57
57
|`/EnableAssessmentUploadToAzureMigrate` | Enables uploading and publishing assessment results to Azure Migrate | N
58
58
|`/AzureCloudEnvironment` |Selects the Azure cloud environment to connect to, default is Azure Public Cloud. Supported values: Azure (default), AzureChina, AzureGermany,AzureUSGovernment. | N
59
-
|`/SubscriptionId` |Azure subscription id. | Y <br> (Required if EnableAssessmentUploadToAzureMigrate argument is specified)
59
+
|`/SubscriptionId` |Azure subscription ID. | Y <br> (Required if EnableAssessmentUploadToAzureMigrate argument is specified)
60
60
|`/AzureMigrateProjectName` |The Azure Migrate Project name to upload assessment results to. | Y <br> (Required if EnableAssessmentUploadToAzureMigrate argument is specified)
61
61
|`/ResourceGroupName` |Azure Migrate resource group name. | Y <br> (Required if EnableAssessmentUploadToAzureMigrate argument is specified)
62
62
|`/AssessmentResultInputFolder` |The input folder path containing .DMA assessment files to upload to Azure Migrate. | Y <br> (Required if Action is AzureMigrateUpload)
Copy file name to clipboardExpand all lines: docs/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql.md
+4-4Lines changed: 4 additions & 4 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -110,10 +110,10 @@ Returns aggregate performance statistics for cached query plans in [!INCLUDE[ssN
110
110
|**min_spills**|**bigint**|The minimum number of pages that this query has ever spilled during a single execution.<br /><br /> **Applies to**: Starting with [!INCLUDE[ssSQL15](../../includes/sssql15-md.md)] SP2 and [!INCLUDE[ssSQL17](../../includes/sssql17-md.md)] CU3|
111
111
|**max_spills**|**bigint**|The maximum number of pages that this query has ever spilled during a single execution.<br /><br /> **Applies to**: Starting with [!INCLUDE[ssSQL15](../../includes/sssql15-md.md)] SP2 and [!INCLUDE[ssSQL17](../../includes/sssql17-md.md)] CU3|
112
112
|**pdw_node_id**|**int**|The identifier for the node that this distribution is on.<br /><br /> **Applies to**: [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)], [!INCLUDE[ssPDW](../../includes/sspdw-md.md)]|
113
-
|**total_page_server_reads**|**bigint**|Total number of remote page server reads performed by executions of this plan since it was compiled.<br /><br /> **Applies to:** Azure SQL DB Hyperscale |
114
-
|**last_page_server_reads**|**bigint**|Number of remote page server reads performed the last time the plan was executed.<br /><br /> **Applies To:** Azure SQL DB Hyperscale |
115
-
|**min_page_server_reads**|**bigint**|Minimum number of remote page server reads that this plan has ever performed during a single execution.<br /><br /> **Applies To:** Azure SQL DB Hyperscale |
116
-
|**max_page_server_reads**|**bigint**|Maximum number of remote page server reads that this plan has ever performed during a single execution.<br /><br /> **Applies To:** Azure SQL DB Hyperscale |
113
+
|**total_page_server_reads**|**bigint**|Total number of remote page server reads performed by executions of this plan since it was compiled.<br /><br /> **Applies to:** Azure SQL Database Hyperscale |
114
+
|**last_page_server_reads**|**bigint**|Number of remote page server reads performed the last time the plan was executed.<br /><br /> **Applies To:** Azure SQL Database Hyperscale |
115
+
|**min_page_server_reads**|**bigint**|Minimum number of remote page server reads that this plan has ever performed during a single execution.<br /><br /> **Applies To:** Azure SQL Database Hyperscale |
116
+
|**max_page_server_reads**|**bigint**|Maximum number of remote page server reads that this plan has ever performed during a single execution.<br /><br /> **Applies To:** Azure SQL Database Hyperscale |
117
117
> [!NOTE]
118
118
> <sup>1</sup> For natively compiled stored procedures when statistics collection is enabled, worker time is collected in milliseconds. If the query executes in less than one millisecond, the value will be 0.
Use the Connect to SQL Azure dialog box to connect to the SQL Azure database that you want to migrate.
16
16
17
17
To access this dialog box, on the **File** menu, select **Connect to SQL Azure**. If you have previously connected, the command is **Reconnect to SQL Azure.**
@@ -40,16 +40,16 @@ Enter the password for the user name.
40
40
41
41
SSMA recommends encrypted connection to SQL Azure.
42
42
43
-
## Create Azure Database
44
-
To create a new azure database, follow the following steps
43
+
## Create database
44
+
To create a new database, follow the following steps
45
45
46
46
1. click on browse button that is present in the Connect to SQL Azure dialog box
47
47
48
48
2. If there are no databases, two menu items appear
49
49
50
50
1.**(no databases found)** which is disabled and grayed out all the time
51
51
52
-
2.**Create new database** which is always enabled, enabling the user to create a new azure database on SQL Azure account. Upon clicking this menu item, create azure database dialog box is present with database name and size.
52
+
2.**Create new database** which is always enabled, enabling the user to create a new database. Upon clicking this menu item, create database dialog box is present with database name and size.
53
53
54
54
3. At the time of database creation, these two parameters is given as input.
Copy file name to clipboardExpand all lines: docs/ssma/db2/connecting-to-sql-server-db2etosql.md
+1-1Lines changed: 1 addition & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -64,7 +64,7 @@ When you define the connection properties, you also specify the database where o
64
64
65
65
7. Click **Connect**.
66
66
67
-
**Higher Version Compatability**
67
+
**Higher Version compatibility**
68
68
69
69
- You will be able to connect to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2008 and [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2012 and [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2014 and [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2016 when the migration project created is [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2005.
# Migrating MySQL Data into SQL Server - Azure SQL DB (MySQLToSQL)
16
+
# Migrating MySQL Data into SQL Server - Azure SQL Database (MySQLToSQL)
17
17
After you have successfully synchronized the converted objects with [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure, you can migrate data from MySQL to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure.
18
18
19
19
> [!IMPORTANT]
@@ -94,13 +94,13 @@ To view migration messages, make sure that the Output pane is visible. Otherwise
94
94
95
95
If the target database is SQL Server, then, enter the connection credentials in the **Connect to SQL Server** dialog box, and click **Connect**. For more information on connecting to SQL Server, see [Connect to SQL Server](https://msdn.microsoft.com/bb8c4bde-cfc2-4636-92ae-5dd24abe9536)
96
96
97
-
If the target database is SQL Azure, then enter the connection credentials in the **Connect to SQL Azure** dialog box, and click **Connect**. For more information on connecting to SQL Azure, see [Connect to Azure SQL DB(MySQLToSQL)](../../ssma/mysql/connect-to-azure-sql-db-mysqltosql.md)
97
+
If the target database is SQL Azure, then enter the connection credentials in the **Connect to SQL Azure** dialog box, and click **Connect**. For more information on connecting to SQL Azure, see [Connect to Azure SQL Database(MySQLToSQL)](../../ssma/mysql/connect-to-azure-sql-db-mysqltosql.md)
98
98
99
99
Messages will appear in the **Output** pane. When the migration is complete, the **Data Migration Report** appears. If any data did not migrate, click the row that contains the errors, and then click **Details**. When you are finished with the report, click **Close**. For more information on Data Migration Report, see [Data Migration Report (SSMA Common)](https://msdn.microsoft.com/bbfb9d88-5a98-4980-8d19-c5d78bd0d241)
100
100
101
101
> [!NOTE]
102
102
> When SQL Express edition is used as the target database, only client side data migration is allowed and server side data migration is not supported.
103
103
104
104
## See Also
105
-
[Migrating MySQL Databases to SQL Server - Azure SQL DB(MySQLToSql)](../../ssma/mysql/migrating-mysql-databases-to-sql-server-azure-sql-db-mysqltosql.md)
105
+
[Migrating MySQL Databases to SQL Server - Azure SQL Database(MySQLToSql)](../../ssma/mysql/migrating-mysql-databases-to-sql-server-azure-sql-db-mysqltosql.md)
# Migrating MySQL Databases to SQL Server - Azure SQL DB (MySQLToSql)
14
+
# Migrating MySQL Databases to SQL Server - Azure SQL Database (MySQLToSql)
15
15
SQL Server Migration Assistant (SSMA) for MySQL is a comprehensive environment that helps you quickly migrate MySQL databases to SQL Server or SQL Azure. By using SSMA for MySQL, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server or SQL Azure, and then migrate data to SQL Server or SQL Azure.
16
16
17
17
## Recommended Migration Process
@@ -27,7 +27,7 @@ To successfully migrate objects and data from MySQL databases to SQL Server or S
27
27
28
28
4.[Mapping MySQL Databases to SQL Server Schemas (MySQLToSQL)](../../ssma/mysql/mapping-mysql-databases-to-sql-server-schemas-mysqltosql.md)
29
29
30
-
5.[Connecting to Azure SQL DB(MySQLToSQL)](../../ssma/mysql/connecting-to-azure-sql-db-mysqltosql.md)
30
+
5.[Connecting to Azure SQL Database(MySQLToSQL)](../../ssma/mysql/connecting-to-azure-sql-db-mysqltosql.md)
31
31
32
32
6. Optionally, [Assessing MySQL Databases for Conversion (MySQLToSQL)](../../ssma/mysql/assessing-mysql-databases-for-conversion-mysqltosql.md) to assess database objects for conversion and estimate the conversion time.
33
33
@@ -41,7 +41,7 @@ To successfully migrate objects and data from MySQL databases to SQL Server or S
41
41
42
42
- Synchronize the database objects.
43
43
44
-
10.[Migrating MySQL Data into SQL Server - Azure SQL DB(MySQLToSQL)](../../ssma/mysql/migrating-mysql-data-into-sql-server-azure-sql-db-mysqltosql.md)
44
+
10.[Migrating MySQL Data into SQL Server - Azure SQL Database(MySQLToSQL)](../../ssma/mysql/migrating-mysql-data-into-sql-server-azure-sql-db-mysqltosql.md)
The SQL Azure project settings let you configure the SQL Azure database suffix to be added in the connection dialog and also allow implementing heartbeat mechanism in SQL Azure connection.
15
15
16
16
The SQL Azure pane is available in the **Project Settings** and **Default Project Settings** dialog boxes.
0 commit comments