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: docs/database-engine/configure-windows/configure-the-remote-data-archive-server-configuration-option.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
@@ -3,7 +3,7 @@ title: "Configure the remote data archive Server Configuration Option"
3
3
description: Learn how to use the remote data archive option in SQL Server to specify whether databases and tables on the server can be enabled for Stretch.
Copy file name to clipboardExpand all lines: docs/database-engine/install-windows/plan-and-test-the-database-engine-upgrade-plan.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
@@ -3,7 +3,7 @@ title: "Plan and Test the Database Engine Upgrade Plan"
3
3
description: This article describes planning before you begin your SQL Server upgrade, including a planning checklist and developing and testing an upgrade plan.
Copy file name to clipboardExpand all lines: docs/dma/dma-assesssqlonprem.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
@@ -2,7 +2,7 @@
2
2
title: "Perform a SQL Server migration assessment"
3
3
titleSuffix: Data Migration Assistant
4
4
description: 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
Copy file name to clipboardExpand all lines: docs/dma/dma-configurationsettings.md
+12-16Lines changed: 12 additions & 16 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,19 +1,17 @@
1
1
---
2
2
title: "Configure settings for Data Migration Assistant"
3
3
description: Learn how to configure settings for the Data Migration Assistant by updating values in the configuration file
4
-
ms.custom: "seo-lt-2019"
5
-
ms.date: 07/20/2022
4
+
author: rajeshsetlem
5
+
ms.author: rajpo
6
+
ms.reviewer: randolphwest
7
+
ms.date: 07/25/2022
6
8
ms.prod: sql
7
9
ms.prod_service: "dma"
8
-
ms.reviewer: randolphwest
9
10
ms.technology: dma
10
11
ms.topic: conceptual
11
-
keywords: ""
12
-
helpviewer_keywords:
12
+
ms.custom: seo-lt-2019
13
+
helpviewer_keywords:
13
14
- "Data Migration Assistant, Assess"
14
-
ms.assetid: ""
15
-
author: rajeshsetlem
16
-
ms.author: rajpo
17
15
---
18
16
19
17
# Configure settings for Data Migration Assistant
@@ -34,7 +32,7 @@ Be sure to save a copy of the original config file before making any modificatio
34
32
35
33
## Number of databases to assess in parallel
36
34
37
-
Data Migration Assistant assesses multiple databases in parallel. During assessment Data Migration Assistant extracts data-tier application (dacpac) to understand the database schema. This operation can time out if several databases on the same server are assessed in parallel.
35
+
Data Migration Assistant assesses multiple databases in parallel. During assessment Data Migration Assistant extracts data-tier application (dacpac) to understand the database schema. This operation can time out if several databases on the same server are assessed in parallel.
38
36
39
37
Starting with Data Migration Assistant v2.0, you can control this by setting the parallelDatabases configuration value. Default value is 8.
40
38
@@ -48,7 +46,7 @@ Starting with Data Migration Assistant v2.0, you can control this by setting the
48
46
49
47
## Number of databases to migrate in parallel
50
48
51
-
Data Migration Assistant migrates multiple databases in parallel, before migrating logins. During migration, Data Migration Assistant will take a backup of the source database, optionally copy the backup, and then restore it on the target server. You may encounter timeout failures when several databases are selected for migration.
49
+
Data Migration Assistant migrates multiple databases in parallel, before migrating logins. During migration, Data Migration Assistant will take a backup of the source database, optionally copy the backup, and then restore it on the target server. You may encounter timeout failures when several databases are selected for migration.
52
50
53
51
Starting with Data Migration Assistant v2.0, if you experience this problem you can reduce the parallelDatabases configuration value. You can increase the value to reduce the overall migration time.
54
52
@@ -62,7 +60,7 @@ Starting with Data Migration Assistant v2.0, if you experience this problem you
62
60
63
61
## DacFX settings
64
62
65
-
During assessment, Data Migration Assistant extracts data-tier application (dacpac) to understand the database schema. This operation can fail with time-outs for extremely large databases, or if the server is under load. Starting with Data Migration v1.0, you can modify the following configuration values to avoid errors.
63
+
During assessment, Data Migration Assistant extracts data-tier application (dacpac) to understand the database schema. This operation can fail with time-outs for large databases, or if the server is under load. Starting with Data Migration v1.0, you can modify the following configuration values to avoid errors.
66
64
67
65
> [!NOTE]
68
66
> The entire `<dacfx>` entry is commented by default. Remove the comments and then modify the value as needed.
@@ -82,8 +80,7 @@ During assessment, Data Migration Assistant extracts data-tier application (dacp
> Stretch Database is deprecated in [!INCLUDE [sssql22-md](../includes/sssql22-md.md)]. [!INCLUDE [ssnotedepfuturedontuse-md](../includes/ssnotedepfuturedontuse-md.md)]
95
92
96
-
With [SQL Server Stretch Database](../sql-server/stretch-database/stretch-database.md), you can dynamically stretch warm and cold transactional data from Microsoft SQL Server 2016 to Azure. The Stretch Database recommendation is no longer availabile as an advisor option.
97
-
93
+
With [SQL Server Stretch Database](../sql-server/stretch-database/stretch-database.md), you can dynamically stretch warm and cold transactional data from Microsoft SQL Server 2016 to Azure. The Stretch Database recommendation is no longer available as an advisor option.
98
94
99
95
## SQL connection timeout
100
96
@@ -109,7 +105,7 @@ for source and target instances while running an assessment or migration, by set
109
105
110
106
## Ignore error codes
111
107
112
-
Each rule has an error code in its title. If you don't need rules and want to ignore them, use the ignoreErrorCodes property. You can specify to ignore a single error or multiple errors. To ignore multiple errors, use a semicolon, e.g., ignoreErrorCodes="46010;71501". The default value is 71501, which is associated with unresolved references identified when an object references system objects such as procedures, views, etc.
108
+
Each rule has an error code in its title. If you don't need rules and want to ignore them, use the `ignoreErrorCodes` property. You can specify to ignore a single error or multiple errors. To ignore multiple errors, use a semicolon, for example, `ignoreErrorCodes="46010;71501"`. The default value is 71501, which is associated with unresolved references identified when an object references system objects such as procedures, views, etc.
Copy file name to clipboardExpand all lines: docs/relational-databases/system-catalog-views/stretch-database-catalog-views-sys-remote-data-archive-databases.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
@@ -4,7 +4,7 @@ description: Learn how sys.remote_data_archive_databases contains one row for ea
Copy file name to clipboardExpand all lines: docs/relational-databases/system-catalog-views/stretch-database-catalog-views-sys-remote-data-archive-tables.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
@@ -4,7 +4,7 @@ description: Learn how sys.remote_data_archive_tables contains one row for each
Copy file name to clipboardExpand all lines: docs/relational-databases/system-dynamic-management-views/stretch-database-sys-dm-db-rda-migration-status.md
description: Learn how sys.dm_db_rda_migration_status contains one row for each batch of migrated data from each Stretch-enabled table on the local instance of SQL Server.
Copy file name to clipboardExpand all lines: docs/relational-databases/system-dynamic-management-views/stretch-database-sys-dm-db-rda-schema-update-status.md
description: Learn how sys.dm_db_rda_schema_update_status contains a row for each schema update task for the remote data archive of each Stretch-enabled table in the database.
0 commit comments