FFFF Fix build errors · debuglevel/sql-docs@1bea128 · GitHub
[go: up one dir, main page]
Skip to content

Commit 1bea128

Browse files
rwestMSFTrwestMSFT
committed
Fix build errors
1 parent 8162b9e commit 1bea128

File tree

3 files changed

+16
-41
lines changed

3 files changed

+16
-41
lines changed

‎docs/dma/dma-configurationsettings.md‎

Lines changed: 13 additions & 38 deletions
Original file line numberDiff line numberDiff line change
@@ -24,11 +24,11 @@ You can find the dma.exe.config file for the Data Migration Assistant desktop ap
2424

2525
- Desktop Application
2626

27-
%ProgramFiles%\\Microsoft Data Migration Assistant\\dma.exe.config
27+
`%ProgramFiles%\Microsoft Data Migration Assistant\dma.exe.config`
2828

2929
- Command-Line Utility
3030

31-
%ProgramFiles%\\Microsoft Data Migration Assistant\\dmacmd.exe.config
31+
`%ProgramFiles%\Microsoft Data Migration Assistant\dmacmd.exe.config`
3232

3333
Be sure to save a copy of the original config file before making any modifications. After making changes, restart Data Migration Assistant for the new configuration values to take effect.
3434

@@ -38,119 +38,94 @@ Data Migration Assistant assesses multiple databases in parallel. During assessm
3838

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

41-
```
41+
```xml
4242
<advisorGroup>
43-
4443
<workflowSettings>
45-
4644
<assessment parallelDatabases="8" />
47-
4845
</workflowSettings>
49-
5046
</advisorGroup>
5147
```
5248

53-
54-
55-
5649
## Number of databases to migrate in parallel
5750

5851
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.
5952

6053
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.
6154

62-
```
55+
```xml
6356
<advisorGroup>
64-
6557
<workflowSettings>
66-
6758
<migration parallelDatabases="8″ />
68-
6959
</workflowSettings>
70-
7160
</advisorGroup>
7261
```
7362
74-
7563
## DacFX settings
7664
7765
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.
7866
7967
> [!NOTE]
80-
> The entire &lt;dacfx&gt; entry is commented by default. Remove the comments and then modify the value as needed.
68+
> The entire `<dacfx>` entry is commented by default. Remove the comments and then modify the value as needed.
8169
8270
- commandTimeout
8371
84-
This parameter sets the IDbCommand.CommandTimeout property in *seconds*. (Default=60)
72+
This parameter sets the IDbCommand.CommandTimeout property in *seconds*. (Default=60)
8573
8674
- databaseLockTimeout
8775
88-
This parameter is equivalent to [SET LOCK\_TIMEOUT timeout\_period](../t-sql/statements/set-lock-timeout-transact-sql.md) in *milliseconds*. (Default=5000)
76+
This parameter is equivalent to [SET LOCK\_TIMEOUT timeout\_period](../t-sql/statements/set-lock-timeout-transact-sql.md) in *milliseconds*. (Default=5000)
8977
9078
- maxDataReaderDegreeOfParallelism
9179
9280
This parameter sets the number of SQL connection pool connections to use. (Default=8)
9381
94-
```
82+
```xml
9583
<advisorGroup>
96-
9784
<advisorSettings>
98-
9985
<dacFx  commandTimeout="60" databaseLockTimeout="5000"
10086
maxDataReaderDegreeOfParallelism="8"/>
101-
10287
</advisorSettings>
103-
10488
</advisorGroup>
10589
```
10690
10791
## Stretch Database: Recommendation threshold
10892
10993
> [!IMPORTANT]
110-
> Stretch Database is deprecated in [!INCLUDE [sssql22-md](../../includes/sssql22-md.md)]. [!INCLUDE [ssnotedepfuturedontuse-md](../../includes/ssnotedepfuturedontuse-md.md)]
94+
> Stretch Database is deprecated in [!INCLUDE [sssql22-md](../includes/sssql22-md.md)]. [!INCLUDE [ssnotedepfuturedontuse-md](../includes/ssnotedepfuturedontuse-md.md)]
11195
11296
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. Stretch Database targets transactional databases with large amounts of cold data. The Stretch Database recommendation, under Storage feature recommendation, first identifies tables that it thinks will benefit from this feature, and then it identifies changes that need to be made to enable the table for this feature.
11397
11498
Starting with Data Migration Assistant v2.0, you can control this threshold for a table to qualify for the Stretch Database feature using the recommendedNumberOfRows configuration value. Default value is 100,000 rows. If you want to analyze the stretch capabilities for even smaller tables, then lower the value accordingly.
11599
116-
```
100+
```xml
117101
<advisorGroup>
118-
119102
<advisorSettings>
120-
121103
<stretchDBAdvisor  recommendedNumberOfRows="100000" />
122-
123104
</advisorSettings>
124-
125105
</advisorGroup>
126106
```
127107
128-
129108
## SQL connection timeout
130109
131110
You can control the [SQL connection time-out](/dotnet/api/system.data.sqlclient.sqlconnection.connectiontimeout)
132111
for source and target instances while running an assessment or migration, by setting the connection timeout value to a specified number of seconds. The default value is 15 seconds.
133112
134-
```
113+
```xml
135114
<appSettings>
136-
137115
<add key="ConnectionTimeout" value="15" />
138-
139116
</appSettings>
140117
```
141118
142119
## Ignore error codes
143120
144121
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.
145122
146-
```
123+
```xml
147124
<workflowSettings>
148-
149125
<assessment parallelDatabases="8" ignoreErrorCodes="71501" />
150-
151126
</workflowSettings>
152127
```
153128
154129
## See also
155130
156-
[Data Migration Assistant Download](https://www.microsoft.com/download/details.aspx?id=53595)
131+
- [Data Migration Assistant Download](https://www.microsoft.com/download/details.aspx?id=53595)

‎docs/dma/dma-whats-new.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -234,7 +234,7 @@ The v2.1 release of Data Migration Assistant includes the following additions:
234234
The v2.0 release of Data Migration Assistant includes improved Stretch database feature recommendations to provide proper prioritized tables that maximize the storage savings.
235235

236236
> [!IMPORTANT]
237-
> Stretch Database is deprecated in [!INCLUDE [sssql22-md](../../includes/sssql22-md.md)]. [!INCLUDE [ssnotedepfuturedontuse-md](../../includes/ssnotedepfuturedontuse-md.md)]
237+
> Stretch Database is deprecated in [!INCLUDE [sssql22-md](../includes/sssql22-md.md)]. [!INCLUDE [ssnotedepfuturedontuse-md](../includes/ssnotedepfuturedontuse-md.md)]
238238
239239
## Data Migration Assistant v1.0
240240

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

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -131,7 +131,7 @@ For details on configuring Always Encrypted, see:
131131
- [Configure Always Encrypted using SSMS](../../../relational-databases/security/encryption/configure-always-encrypted-using-sql-server-management-studio.md)
132132
- [Configure Always Encrypted using PowerShell](../../../relational-databases/security/encryption/configure-always-encrypted-using-powershell.md)
133133

134-
## Get started with Always Encrypted
134+
## <a id="getting-started-with-always-encrypted"></a> Get started with Always Encrypted
135135

136136
Use the [Always Encrypted Wizard](../../../relational-databases/security/encryption/always-encrypted-wizard.md) to quickly start using Always Encrypted. The wizard will provision the required keys and configure encryption for selected columns. If the columns you're setting encryption for already contain some data, the wizard will encrypt the data. The following example demonstrates the process for encrypting a column.
137137

@@ -186,7 +186,7 @@ Always Encrypted isn't supported for the columns with the below characteristics.
186186
- Columns in Stretch Database tables. (Tables with columns encrypted with Always Encrypted can be enabled for Stretch.)
187187

188188
> [!IMPORTANT]
189-
> Stretch Database is deprecated in [!INCLUDE [sssql22-md](../../includes/sssql22-md.md)]. [!INCLUDE [ssnotedepfuturedontuse-md](../../includes/ssnotedepfuturedontuse-md.md)]
189+
> Stretch Database is deprecated in [!INCLUDE [sssql22-md](../../../includes/sssql22-md.md)]. [!INCLUDE [ssnotedepfuturedontuse-md](../../../includes/ssnotedepfuturedontuse-md.md)]
190190
191191
- Columns in external (PolyBase) tables (note: using external tables and tables with encrypted columns in the same query is supported).
192192
- Table-valued parameters targeting encrypted columns aren't supported.

0 commit comments

Comments
 (0)
0