Data Access Migration Toolkit

Preview

Microsoft

|
3,940 installs
| (2) | Free
Analyze database access in your application.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

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)

Current supported source database backends

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

Third Party Software

See our third party notice file for information about third-party software used in this extension.