Skip to content

Commit b0bf017

Browse files
committed
Fix date
1 parent a6f1e83 commit b0bf017

38 files changed

Lines changed: 49 additions & 53 deletions

File tree

docs/database-engine/configure-windows/configure-the-remote-data-archive-server-configuration-option.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@ title: "Configure the remote data archive Server Configuration Option"
33
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.
44
author: rwestMSFT
55
ms.author: randolphwest
6-
ms.date: 07/20/2022
6+
ms.date: 07/25/2022
77
ms.prod: sql
88
ms.prod_service: high-availability
99
ms.technology: configuration

docs/database-engine/install-windows/plan-and-test-the-database-engine-upgrade-plan.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@ title: "Plan and Test the Database Engine Upgrade Plan"
33
description: This article describes planning before you begin your SQL Server upgrade, including a planning checklist and developing and testing an upgrade plan.
44
author: rwestMSFT
55
ms.author: randolphwest
6-
ms.date: 07/20/2022
6+
ms.date: 07/25/2022
77
ms.prod: sql
88
ms.technology: install
99
ms.topic: conceptual

docs/dma/dma-assesssqlonprem.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
title: "Perform a SQL Server migration assessment"
33
titleSuffix: Data Migration Assistant
44
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
5-
ms.date: 07/20/2022
5+
ms.date: 07/25/2022
66
ms.prod: sql
77
ms.prod_service: "dma"
88
ms.reviewer: randolphwest

docs/dma/dma-configurationsettings.md

Lines changed: 12 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -1,19 +1,17 @@
11
---
22
title: "Configure settings for Data Migration Assistant"
33
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
68
ms.prod: sql
79
ms.prod_service: "dma"
8-
ms.reviewer: randolphwest
910
ms.technology: dma
1011
ms.topic: conceptual
11-
keywords: ""
12-
helpviewer_keywords:
12+
ms.custom: seo-lt-2019
13+
helpviewer_keywords:
1314
- "Data Migration Assistant, Assess"
14-
ms.assetid: ""
15-
author: rajeshsetlem
16-
ms.author: rajpo
1715
---
1816

1917
# 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
3432

3533
## Number of databases to assess in parallel
3634

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.
3836

3937
Starting with Data Migration Assistant v2.0, you can control this by setting the parallelDatabases configuration value. Default value is 8.
4038

@@ -48,7 +46,7 @@ Starting with Data Migration Assistant v2.0, you can control this by setting the
4846

4947
## Number of databases to migrate in parallel
5048

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.
5250

5351
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.
5452

@@ -62,7 +60,7 @@ Starting with Data Migration Assistant v2.0, if you experience this problem you
6260
6361
## DacFX settings
6462
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.
6664
6765
> [!NOTE]
6866
> 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
8280
```xml
8381
<advisorGroup>
8482
<advisorSettings>
85-
<dacFx  commandTimeout="60" databaseLockTimeout="5000"
86-
maxDataReaderDegreeOfParallelism="8"/>
83+
<dacFx commandTimeout="60" databaseLockTimeout="5000" maxDataReaderDegreeOfParallelism="8"/>
8784
</advisorSettings>
8885
</advisorGroup>
8986
```
@@ -93,8 +90,7 @@ maxDataReaderDegreeOfParallelism="8"/>
9390
> [!IMPORTANT]
9491
> Stretch Database is deprecated in [!INCLUDE [sssql22-md](../includes/sssql22-md.md)]. [!INCLUDE [ssnotedepfuturedontuse-md](../includes/ssnotedepfuturedontuse-md.md)]
9592
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.
9894
9995
## SQL connection timeout
10096
@@ -109,7 +105,7 @@ for source and target instances while running an assessment or migration, by set
109105
110106
## Ignore error codes
111107
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.
113109
114110
```xml
115111
<workflowSettings>

docs/dma/dma-whats-new.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@ title: "What's new in Data Migration Assistant (SQL Server)"
33
description: Learn about the new features in each release of Data Migration Assistant for SQL Server and Azure SQL Database.
44
ms.custom:
55
- intro-whats-new
6-
ms.date: 07/20/2022
6+
ms.date: 07/25/2022
77
ms.prod: sql
88
ms.prod_service: "dma"
99
ms.reviewer: randolphwest

docs/relational-databases/security/encryption/always-encrypted-database-engine.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ description: Overview of Always Encrypted that supports transparent client-side
44
author: jaszymas
55
ms.author: jaszymas
66
ms.reviewer: vanto, randolphwest
7-
ms.date: 07/20/2022
7+
ms.date: 07/25/2022
88
ms.prod: sql
99
ms.technology: security
1010
ms.topic: conceptual

docs/relational-databases/system-catalog-views/stretch-database-catalog-views-sys-remote-data-archive-databases.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ description: Learn how sys.remote_data_archive_databases contains one row for ea
44
author: rwestMSFT
55
ms.author: randolphwest
66
ms.reviewer: mikeray
7-
ms.date: 07/20/2022
7+
ms.date: 07/25/2022
88
ms.prod: sql
99
ms.technology: stored-procedures
1010
ms.topic: "reference"

docs/relational-databases/system-catalog-views/stretch-database-catalog-views-sys-remote-data-archive-tables.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ description: Learn how sys.remote_data_archive_tables contains one row for each
44
author: rwestMSFT
55
ms.author: randolphwest
66
ms.reviewer: mikeray
7-
ms.date: 07/20/2022
7+
ms.date: 07/25/2022
88
ms.prod: sql
99
ms.technology: stored-procedures
1010
ms.topic: "reference"

docs/relational-databases/system-dynamic-management-views/stretch-database-sys-dm-db-rda-migration-status.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@ title: "sys.dm_db_rda_migration_status (Transact-SQL)"
33
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.
44
author: rwestMSFT
55
ms.author: randolphwest
6-
ms.date: 07/20/2022
6+
ms.date: 07/25/2022
77
ms.prod: sql
88
ms.technology: stored-procedures
99
ms.topic: "reference"

docs/relational-databases/system-dynamic-management-views/stretch-database-sys-dm-db-rda-schema-update-status.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@ title: "sys.dm_db_rda_schema_update_status (Transact-SQL)"
33
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.
44
author: rwestMSFT
55
ms.author: randolphwest
6-
ms.date: 07/20/2022
6+
ms.date: 07/25/2022
77
ms.prod: sql
88
ms.technology: stored-procedures
99
ms.topic: "reference"

0 commit comments

Comments
 (0)