microsoft/ssma

SQL Server Migration Assistant

This GitHub repository is for reporting any of the SQL Server Migration Assistant (SSMA) related issues. Issues submitted will be reviewed and answered by engineering team.

Microsoft SQL Server Migration Assistant (SSMA) is a tool designed to automate database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and SAP ASE.

Public Documentation : SQL Server Migration Assistant - SQL Server | Microsoft Docs

Contributing

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.

ssma's Issues

Object reference not defined

Object reference not defined

Issue Type: Bug

When doing Convert, Load, and Migrate of an ACCESS table I received an error message:"An unexpected error occured. Please send the log file to product support.
Where do I found the contact details for the support of SSMA?

---

Tool version: SSMA for Access 9.5.23323.1001 (32 bit)
OS version: Microsoft Windows NT 10.0.22621.0
Correlation: 41b7ecf3-9c70-42b0-ade7-2a034cdaedae

Objet non défini

Objet non défini

Issue Type: référence d'objet n'est pas définie à une instance d'objet

Starting conversion...
Analyzing metadata...
Converting table Samod_Relèves.[AMaTable_Elec] ...
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ResultID' was converted to a check constraint.
Errors: An unhandled exception occured while converting Samod_Relèves.[AMaTable_Elec] table
For more information, see the Log file
Conversion finished with 1 errors, 0 warnings, and 1 informational messages.
An unexpected error occurred. Please send the log file to product support. For more information, see "Getting SSMA Assistance" in the product documentation.
La référence d'objet n'est pas définie à une instance d'un objet.

---

Tool version: SSMA for Access 9.5.23323.1001 (32 bit)
OS version: Microsoft Windows NT 10.0.22621.0
Correlation: 96ca1199-b98a-4b40-8d37-f2bf79782d2b

Change target database

Change target database

Issue Type: Feature Requests

Hi,

As SSMA (Ms Access version) is a 'project oriented' application, it would be particularly useful to be able to change the target database, so that test and live outputs can be used.

Thanks.

---

Tool version: SSMA for Access 9.4.23215.1002
OS version: Microsoft Windows NT 10.0.19045.0
Correlation: 06f2e1b6-086c-4c01-98d6-ec72689f2bc3

Ignore Zero Length constraints

Ignore Zero Length constraints

Issue Type: Feature Requests

Hi,

The zero length property on text fields in Microsoft Access are translated as constraints to target SQL databases. This can cause major issues when translating data as rows can be omitted from the target database. In the worst extremes, I have seen entire tables without data due to there being several text fields with the constraint attached.

Thanks.

---

Tool version: SSMA for Access 9.4.23215.1002
OS version: Microsoft Windows NT 10.0.19045.0
Correlation: 06f2e1b6-086c-4c01-98d6-ec72689f2bc3

Can't Migrate iSeries DB2 Tables to SQL

Can't Migrate iSeries DB2 Tables to SQL

Issue Type: Bug

It's failing to read the table schema or data so it doesn't have the info needed to build the table in SQL.

"Unable to show data for the unloaded table for the following reason: "

CREATE TABLE BRERC0DAT.BREPLBYSYM
( 
);

---

Tool version: SSMA for Db2 9.4.23215.1002
OS version: Microsoft Windows NT 10.0.19045.0
Correlation: cbead705-3f98-488d-9223-a9243c4fa041

Test

Issue Type: Performance Issue

Issue: Test

Description:

TESTING

---

TESTING!@#

---

Tool version: SSMA for Oracle 8.24.0.0
OS version: Microsoft Windows NT 10.0.22000.0
Correlation: 7aedbf13-e218-4a20-bdd8-cf4cfad249d1

How to get debug logs?

How to get SSMA debug logs

Migrationcontext

Migrationcontext

Issue Type: Feature Request

• I don't want to migrate all Fields of my Tables. Fields should be unselectable to be ignored.
• Some Fields should get new Fieldnames (to change language or implement naming rules)

---

Tool version: SSMA for Access 9.2.22312.1001 (32 bit)
OS version: Microsoft Windows NT 10.0.19045.0
Correlation: e855f056-9778-49d4-a529-b0c2653255c2