Data Access Migration Toolkit

The Data Access Migration Toolkit provides tools to help migrate application source code from one database platform to another.

Discover and extract SQL queries from files
Catalog data access APIs used (Java only)

Supported source database backends

IBM DB2
Oracle Database
SQL Server

Current supported file types

Java
C#
XML
JSON
Properties
SQL files
Plain text / Unstructured

Commands

Analyze workspace

Scans the entire workspace for database usage and SQL queries, generating a report. Files will be re-scanned on save.

Sample report header

Analyze file

Scans the current file for database usage and SQL queries.

Source code file with connection string highlighted

Clear problems

Clear all warnings from the problems pane, and stops scanning on save.

Help

Show the help page.

Analyzing compatibility issues for SQL Server modernization

You can use this extension to find compatibility issues when you migrate from on-premises SQL Server to Azure SQL Database. If running an analysis for the SQL Server dialect, simply choose to save your results as a JSON report, then use them as an additional source of adhoc queries in the Microsoft Data Migration Assistant.

Privacy Statement

The Microsoft Enterprise and Developer Privacy Statement describes the privacy statement of this software.