Skip to content

Commit b41ee4b

Browse files
nahk-ivanovnahk-ivanov
committed
Update 'what's new' articles for SSMA v8.7.
I also noticed that there were some MD lint issues, so I addressed them as well in the documents I modified. I thne improved formatting (used code blocks) for clauses and updated includes for different SQL Server versions. It turned out there was no template for SQL 2008, so I added one following existing naming convention.
1 parent 7a6bb81 commit b41ee4b

7 files changed

Lines changed: 423 additions & 367 deletions

‎docs/includes/sssql10-md.md‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
SQL Server 2008 (10.x)

‎docs/ssma/access/what-s-new-in-ssma-for-access-accesstosql.md‎

Lines changed: 78 additions & 70 deletions
Original file line numberDiff line numberDiff line change
@@ -1,19 +1,27 @@
11
---
22
title: "What's New in SSMA for Access (AccessToSQL) | Microsoft Docs"
3+
authors: "HJToland3;nahk-ivanov"
4+
35
ms.prod: sql
46
ms.custom: ""
5-
ms.date: "01/22/2020"
7+
ms.date: "3/2/2020"
68
ms.reviewer: ""
79
ms.technology: ssma
810
ms.topic: conceptual
911
ms.assetid: a24d3fc0-6911-4bfa-828a-197abf222e02
10-
author: "HJToland3"
11-
ms.author: "Shamikg"
12+
ms.author: "jtoland;alexiva"
1213
---
1314
# What's New in SSMA for Access (AccessToSQL)
1415

1516
This article lists SQL Server Migration Assistant (SSMA) for Access changes in each release.
1617

18+
## SSMA v8.7
19+
20+
The v8.7 release of SSMA for Access has improved conversion for `IIF` function in queries, as well as minor fixes and performance improvements in graphical user interface.
21+
22+
> [!IMPORTANT]
23+
> With SSMA v8.5 and later, .Net 4.7.2 is an installation pre-requisite. If you need to install this version, you can download the runtime file from [here](https://dotnet.microsoft.com/download/dotnet-framework/net472).
24+
1725
## SSMA v8.6
1826

1927
In addition to a targeted set of fixes designed to improve usability and performance, the v8.6 release of SSMA for Access has been enhanced by adding a setting that enables users to omit SSMA extended properties in the converted code.
@@ -29,7 +37,7 @@ To leverage this setting, in SSMA for Access, navigate to **Tools** > **Project
2937

3038
The v8.5 release of SSMA for Access is enhanced with support for Azure Active Directory authentication and basic support for JSON features in SQL server, together with a targeted set of fixes designed to improve usability and performance.
3139

32-
In addition, SSMA for Access now supports conversion of multiple standard functions (ISNULL, IIF, etc.).
40+
In addition, SSMA for Access now supports conversion of multiple standard functions (`ISNULL`, `IIF`, etc.).
3341

3442
> [!IMPORTANT]
3543
> With SSMA v8.5, .Net 4.7.2 is an installation pre-requisite. If you need to install this version, you can download the runtime file from [here](https://dotnet.microsoft.com/download/dotnet-framework/net472).
@@ -45,8 +53,8 @@ The v8.4 release of SSMA for Access is enhanced with targeted fixes that are des
4553

4654
The v8.3 release of SSMA for Access is enhanced with targeted fixes that are designed to improve quality and conversion metrics. In addition, this release of SSMA for Access provides fixes that:
4755

48-
* Address accessibility issues
49-
* Add basic support for 'hierarchyid' type in SQL Server
56+
* Address accessibility issues.
57+
* Add basic support for `hierarchyid` type in SQL Server.
5058

5159
## SSMA v8.2
5260

@@ -156,108 +164,108 @@ The v7.1 release of SSMA for Access contains the following changes:
156164

157165
## May 2016
158166

159-
The May 2016 release of SSMA for Access contains the following changes:
160-
161-
* Added official support for SQL Server 2016
167+
The May 2016 release of SSMA for Access contains the following changes:
168+
169+
* Added official support for SQL Server 2016.
162170
* Removed installer check for .Net 2.0.
163-
* Fixed "save project" and "open project" commands for SSMA Console.
164-
* Fixed "securepassword" command for SSMA Console.
171+
* Fixed `save-project` and `open-project` commands for SSMA Console.
172+
* Fixed `securepassword` command for SSMA Console.
165173
* Fixed counting of objects for initial loading.
166174
* Fixed tables data loading for UI tabs for Access.
167175
* Fixed bug in global settings.
168176

169177
## March 2016
170178

171-
The March 2016 preview release of SSMA for Access adds support for migration to SQL Server 2016.
179+
The March 2016 preview release of SSMA for Access adds support for migration to SQL Server 2016.
172180

173181
## January 2016
174182

175-
The January 2016 maintenance release of SSMA for Access contains the following changes:
176-
177-
* Fixed invalid function for default of a GUID field (RFC 3894811).
178-
* Fixed hang on importing records to SQL Database (Azure) (RFC 4919573).
179-
* Added View Log Menu Item to SSMA (RFC 5706203).
183+
The January 2016 maintenance release of SSMA for Access contains the following changes:
184+
185+
* Fixed invalid function for default of a GUID field (RFC 3894811).
186+
* Fixed hang on importing records to SQL Database (Azure) (RFC 4919573).
187+
* Added View Log Menu Item to SSMA (RFC 5706203).
180188
* Added Telemetry.
181-
189+
182190
## July 2014
183191

184-
The July 2014 release of SSMA for Access contains the following changes:
185-
186-
* Improved Azure SQL DB code conversion.
187-
* Moved extension pack functionality to schema to support Azure SQL DB.
188-
* Tested performance improvements for databases with over 10k objects.
189-
* Added UI improvements for dealing with large number of objects.
190-
* Added support for highlighting of "well known" LOB schemas (so they can be ignored in conversion).
192+
The July 2014 release of SSMA for Access contains the following changes:
193+
194+
* Improved Azure SQL DB code conversion.
195+
* Moved extension pack functionality to schema to support Azure SQL DB.
196+
* Tested performance improvements for databases with over 10k objects.
197+
* Added UI improvements for dealing with large number of objects.
198+
* Added support for highlighting of "well known" LOB schemas (so they can be ignored in conversion).
191199
* Added conversion speed improvements.
192200
* Added support for showing object counts in UI.
193201
* Reduced report size by more than 25%.
194-
* Improved error messages for unparsed constructs.
195-
202+
* Improved error messages for unparsed constructs.
203+
196204
## April 2014
197205

198-
The April 2014 release of SSMA for Access contains the following changes:
199-
206+
The April 2014 release of SSMA for Access contains the following changes:
207+
200208
* Added support for MS SQL Server 2014.
201-
* Fixed bugs related to conversion to Azure.
202-
* Fixed bugs related to invisible report pages in IE 10.
203-
209+
* Fixed bugs related to conversion to Azure.
210+
* Fixed bugs related to invisible report pages in IE 10.
211+
204212
## January 2012
205213

206-
The January 2012 release of SSMA for Access contains the following changes:
207-
208-
* Provided the option to not persist username and password for MS Access linked tables after migration.
209-
* Set cascade actions for circular references to No Action.
210-
* Provided proper messages indicating cascade actions for circular references have been set to No Action.
211-
214+
The January 2012 release of SSMA for Access contains the following changes:
215+
216+
* Provided the option to not persist username and password for MS Access linked tables after migration.
217+
* Set cascade actions for circular references to No Action.
218+
* Provided proper messages indicating cascade actions for circular references have been set to No Action.
219+
212220
## July 2011
213221

214-
The July 2011 release of SSMA for Access adds improved error reporting during data migration.
215-
222+
The July 2011 release of SSMA for Access adds improved error reporting during data migration.
223+
216224
## April 2011
217225

218-
The April 2011 release of SSMA for Access contains the following changes:
219-
220-
* Added a single installable of "SSMA for Access", which supports [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2005, [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2008, [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] "Denali" and Azure SQL.
221-
* Added the ability to connect [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] "Denali."
226+
The April 2011 release of SSMA for Access contains the following changes:
227+
228+
* Added a single installable of "SSMA for Access", which supports [!INCLUDE [ssVersion2005](../../includes/ssversion2005-md.md)], [!INCLUDE [ssSQL10](../../includes/sssql10-md.md)], [!INCLUDE [ssSQL11](../../includes/sssql11-md.md)] and Azure SQL.
229+
* Added the ability to connect to [!INCLUDE [ssSQL11](../../includes/sssql11-md.md)].
222230
* Added SSMA for Access Console version support for backward compatibility. You can open the projects created by versions earlier to SSMA v5.0.
223-
* Added the ability to install SSMA v5.0 product side by side (SxS) with older versions of SSMA Product.
224-
231+
* Added the ability to install SSMA v5.0 product side by side (SxS) with older versions of SSMA Product.
232+
225233
## July 2010
226234

227-
The July 2010 release of SSMA for Access contains the following changes:
228-
235+
The July 2010 release of SSMA for Access contains the following changes:
236+
229237
* Added support for migrating to SQL Server 2008 R2 and Azure SQL.
230-
* Added a secure connection to both SQL Server and Azure SQL.
238+
* Added a secure connection to both SQL Server and Azure SQL.
231239
* Added support for Access 2010 databases.
232240
* Added a new SSMA Console application for command-line execution.
233-
* Added support for the SQL Server DateTime2 data type.
234-
241+
* Added support for the SQL Server `DateTime2` data type.
242+
235243
## June 2008
236244

237-
The June 2008 release of SSMA for Access adds support for Access 2007 databases.
238-
245+
The June 2008 release of SSMA for Access adds support for Access 2007 databases.
246+
239247
## May 2007
240248

241-
The May 2007 release of SSMA for Access contains the following changes:
242-
243-
* Added support for Access databases that use workgroup policies.
244-
* Provided the ability to delete converted objects from the SQL Server metadata explorer.
245-
* Added support for user-entered comments in the SQL Server formatted SQL mode.
246-
* Added improvements in object conversion.
247-
249+
The May 2007 release of SSMA for Access contains the following changes:
250+
251+
* Added support for Access databases that use workgroup policies.
252+
* Provided the ability to delete converted objects from the SQL Server metadata explorer.
253+
* Added support for user-entered comments in the SQL Server formatted SQL mode.
254+
* Added improvements in object conversion.
255+
248256
## November 2006
249257

250-
The November 2006 release of SSMA for Access contains the following changes:
251-
252-
* Added a new Database Migration Wizard that guides you through the migration of a single database from Access to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].
253-
* Added a new Convert, Load, and Migrate command that converts Access databases, loads the converted objects into [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], and migrates data into [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] all in one step.
254-
* Improved query migration. Query migration now converts more SELECT queries to views. For more information, see [Converting Access Database Objects](converting-access-database-objects-accesstosql.md).
255-
* Added the ability to edit table and index properties on the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] **Table** tab.
258+
The November 2006 release of SSMA for Access contains the following changes:
259+
260+
* Added a new Database Migration Wizard that guides you through the migration of a single database from Access to [!INCLUDE [ssNoVersion](../../includes/ssnoversion-md.md)].
261+
* Added a new Convert, Load, and Migrate command that converts Access databases, loads the converted objects into [!INCLUDE [ssNoVersion](../../includes/ssnoversion-md.md)], and migrates data into [!INCLUDE [ssNoVersion](../../includes/ssnoversion-md.md)] all in one step.
262+
* Improved query migration. Query migration now converts more SELECT queries to views. For more information, see [Converting Access Database Objects](converting-access-database-objects-accesstosql.md).
263+
* Added the ability to edit table and index properties on the [!INCLUDE [ssNoVersion](../../includes/ssnoversion-md.md)] **Table** tab.
256264
* Added new global settings:
257-
* You can opt to show line numbers in editor windows.
258-
* You can configure SSMA to prompt to replace duplicate objects, or always or never replace duplicate objects during schema conversion.
259-
* Added a new conversion option that lets you specify whether SSMA displays a warning when a complex query contains a wildcard.
260-
265+
* You can opt to show line numbers in editor windows.
266+
* You can configure SSMA to prompt to replace duplicate objects, or always or never replace duplicate objects during schema conversion.
267+
* Added a new conversion option that lets you specify whether SSMA displays a warning when a complex query contains a wildcard.
268+
261269
## July 2006
262270

263271
The July 2006 release of SSMA for Access was the initial release.

‎docs/ssma/db2/what-s-new-in-ssma-for-db2-db2tosql.md‎

Lines changed: 47 additions & 30 deletions
Original file line numberDiff line numberDiff line change
@@ -1,19 +1,36 @@
11
---
22
title: "What's New in SSMA for DB2 (DB2ToSQL) | Microsoft Docs"
3+
authors: "HJToland3;nahk-ivanov"
4+
35
ms.prod: sql
46
ms.custom: ""
5-
ms.date: "01/22/2020"
7+
ms.date: "3/2/2020"
68
ms.reviewer: ""
79
ms.technology: ssma
810
ms.topic: conceptual
911
ms.assetid: 1cc38f85-3caa-42d0-8c76-a380c1d15c67
10-
author: "HJToland3"
11-
ms.author: "Shamikg"
12+
ms.author: "jtoland;alexiva"
1213
---
1314
# What's New in SSMA for DB2 (DB2ToSQL)
1415

1516
This article lists SQL Server Migration Assistant (SSMA) for DB2 changes in each release.
1617

18+
## SSMA v8.7
19+
20+
The v8.7 release of SSMA for DB2 includes brand new DB2 syntax parser, as well as minor fixes and performance improvements in graphical user interface.
21+
22+
In addition, SSMA for DB2 now provides:
23+
24+
* A fix for discovery of foreign keys when migrating from DB2 on LUW.
25+
* Improved conversion of `SELECT ... FOR UPDATE` statement.
26+
* Improved conversion for `COUNT` function in MQ tables.
27+
* Conversion of `SAVEPOINT` statements.
28+
* Conversion to emulate DB2's behavior for `NULL` values in `ORDER BY` clause.
29+
* Parsing support for ASSOCIATE RESULT SET statement.
30+
31+
> [!IMPORTANT]
32+
> With SSMA v8.5 and later, .Net 4.7.2 is an installation pre-requisite. If you need to install this version, you can download the runtime file from [here](https://dotnet.microsoft.com/download/dotnet-framework/net472).
33+
1734
## SSMA v8.6
1835

1936
In addition to a targeted set of fixes designed to improve usability and performance, the v8.6 release of SSMA for DB2 has been enhanced by adding a setting that enables users to omit SSMA extended properties in the converted code.
@@ -24,9 +41,9 @@ To leverage this setting, in SSMA for DB2, navigate to **Tools** > **Project Set
2441

2542
In addition, SSMA for DB2 now provides:
2643

27-
- A fix for conversion of functions that use default argument values
28-
- Improved parsing of functions in the PARAMETER clause.
29-
- The ability to convert the LEAVE statement.
44+
* A fix for conversion of functions that use default argument values.
45+
* Improved parsing of the `PARAMETER` clause for functions.
46+
* The ability to convert the `LEAVE` statement.
3047

3148
> [!IMPORTANT]
3249
> With SSMA v8.5 and later, .Net 4.7.2 is an installation pre-requisite. If you need to install this version, you can download the runtime file from [here](https://dotnet.microsoft.com/download/dotnet-framework/net472).
@@ -37,7 +54,7 @@ The v8.5 release of SSMA for DB2 is enhanced with support for Azure Active Direc
3754

3855
In addition, SSMA for DB2 has been enhanced with:
3956

40-
* Support for adding conversion for GET DIAGNOSTICS statement with ROW_NUMBER.
57+
* Support for adding conversion for `GET DIAGNOSTICS` statement with `ROW_NUMBER`.
4158
* A fix for a bug related to spaces at the beginning of the object name not being respected.
4259

4360
> [!IMPORTANT]
@@ -54,23 +71,23 @@ The v8.4 release of SSMA for DB2 is enhanced with targeted fixes that are design
5471

5572
The v8.3 release of SSMA for DB2 is enhanced with targeted fixes that are designed to improve quality and conversion metrics. In addition, this release of SSMA for DB2 provides fixes that:
5673

57-
* Address accessibility issues
58-
* Add basic support for 'hierarchyid' type in SQL Server
59-
* Replace TRIM function usage in z/OS discovery queries with RTRIM/LTRIM
60-
* Allow user to specify Package Collection when connecting in “Standard mode” (defaults to NULLID)
61-
* Add conversion for CREATE TABLE AS SELECT
62-
* Improve conversions for global temp tables
63-
* Address an issue with object uniqueness check order to prioritize tables over constraints, if names collide
64-
* Address an issue with loading of default column values for DATE and TIMESTAMP for z/OS
65-
* Support Unicode line feed character (also known as NEL)
66-
* Address an issue with cursor conversion with missing RETURN TO clause
67-
* Add support for labels and GOTO
74+
* Address accessibility issues.
75+
* Add basic support for `hierarchyid` type in SQL Server.
76+
* Replace TRIM function usage in z/OS discovery queries with `RTRIM`/`LTRIM`.
77+
* Allow user to specify Package Collection when connecting in 'Standard mode' (defaults to `NULLID`).
78+
* Add conversion for `CREATE TABLE AS SELECT`.
79+
* Improve conversions for global temp tables.
80+
* Address an issue with object uniqueness check order to prioritize tables over constraints, if names collide.
81+
* Address an issue with loading of default column values for `DATE` and `TIMESTAMP` for z/OS.
82+
* Support Unicode line feed character (also known as `NEL`).
83+
* Address an issue with cursor conversion with missing `RETURN TO` clause.
84+
* Add support for labels and `GOTO`.
6885

6986
## SSMA v8.2
7087

7188
The v8.2 release of SSMA for DB2 is enhanced with to address issues with connections to Azure SQL Database from the SSMA console tool and missing COUNT_BIG column in views declaration during conversion. In addition, this version includes a targeted set of fixes designed to improve quality and conversion metrics, as well as fixes for:
7289

73-
* An issue with disabled nonclustered indexes after data migration.
90+
* An issue with disabled non-clustered indexes after data migration.
7491
* Detection of .NET Framework during silent installation.
7592
* An intermittent crash that occurs when a new version is downloaded.
7693

@@ -105,7 +122,7 @@ The v8.0 release of SSMA for DB2 is enhanced to provide targeted fixes designed
105122
The v7.10 release of SSMA for DB2 contains the following changes:
106123

107124
* Targeted fixes designed to provide additional security and privacy protections to meet changes in global requirements.
108-
* A fix for conversion of BEGIN-END blocks.
125+
* A fix for conversion of `BEGIN-END` blocks.
109126

110127
## SSMA v7.9
111128

@@ -120,7 +137,7 @@ The v7.9 release of SSMA for DB2 contains the following changes:
120137

121138
The v7.8 release of SSMA for DB2 contains the following changes:
122139

123-
* Change type mapping highlighted in Project Settings.
140+
* Change type mapping highlighted in *Project Settings*.
124141
* The ability for users to disable telemetry.
125142

126143
## SSMA v7.7
@@ -183,7 +200,7 @@ The v7.1 release of SSMA for DB2 contains the following changes:
183200

184201
## May 2016
185202

186-
The May 2016 release of SSMA for DB2 contains the following changes:
203+
The May 2016 release of SSMA for DB2 contains the following changes:
187204

188205
* Added support for SQL Server 2016.
189206
* Added conversion of DB2 in-memory and regular tables to SQL Server in-memory and hekaton features.
@@ -192,8 +209,8 @@ The May 2016 release of SSMA for DB2 contains the following changes:
192209
* Improved DB2 parser and resolver.
193210
* Removed installer check for .Net 2.0.
194211
* Removed unnecessary *.dll from Db2 installer.
195-
* Fixed "save project" and "open project" commands for SSMA Console.
196-
* Fixed "securepassword" command for SSMA Console.
212+
* Fixed `save-project` and `open-project` commands for SSMA Console.
213+
* Fixed `securepassword` command for SSMA Console.
197214
* Fixed counting of objects for initial loading.
198215
* Fixed bug in global settings.
199216

@@ -203,13 +220,13 @@ The March 2016 preview release of SSMA for DB2 adds support for migration to SQL
203220

204221
## January 2016
205222

206-
The January 2016 maintenance release of SSMA for DB2 contains the following changes:
223+
The January 2016 maintenance release of SSMA for DB2 contains the following changes:
207224

208-
* Added support for a number of standard functions.
209-
* Fixed DB2 Parser Errors.
210-
* Fixed DB2 v9 zOS Support (RFC 5690920).
211-
* Fixed DB2 unresolved identifier errors during conversion.
212-
* Added View Log Menu Item to SSMA (RFC 5706203).
225+
* Added support for a number of standard functions.
226+
* Fixed DB2 Parser Errors.
227+
* Fixed DB2 v9 zOS Support (RFC 5690920).
228+
* Fixed DB2 unresolved identifier errors during conversion.
229+
* Added View Log Menu Item to SSMA (RFC 5706203).
213230
* Added Telemetry.
214231

215232
## November 2014

0 commit comments

Comments
 (0)