Skip to content

What do you think about Visual Studio Marketplace? We are looking for feedback from developers like you! Take the survey

| Marketplace
Sign in
Visual Studio Code>Programming Languages>Data Access Migration ToolkitNew to Visual Studio Code? Get it now.

Data Access Migration Toolkit

Preview

Microsoft

|
19,571 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)

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.

  • Contact us
  • Jobs
  • Privacy
  • Terms of use
  • Trademarks
© 2023 Microsoft