Share via

Azure SQL Migration tool (from Azure Data Studio) does not catch cross database query in Extended Event trace

Alessandro Colombi 0 Reputation points
2024-08-30T16:30:38.66+00:00

Hello all,

we are running a migrazion assessment using Azure SQL Migration extension from Azure Data Studio. We need to migrate from SQL Server to Azure (Elastic pool or Managed instance).

We have upload in the tool an Extended Event trace which included cross database queries.

The assessment result show some findings but does not catch cross database query which are included in the .xel trace.

We also created a stored procedure which run cross database queries. In that case Azure SQL Migration tool caugth the object in the database and show up the related findings.

Do you have any idea if this is a tool's bug or simply if this information is not catch/analyze during the assessment?

What if the meaning of load the .xel trace if those important details are not caugth?

Thank you in advance

Alessandro

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,049 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
540 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 112.8K Reputation points
    2024-08-30T21:43:07.2266667+00:00

    It does not sound like a bug to me, but rather a limitation. But quite a serious limitation, since these queries are showstopper for an migration to Azure SQL Database.

    A good place to suggest bugs and suggestions is https://feedback.azure.com/forums/908035-sql-server

    Although, it occurs to me that Azure Data Studio has a github repo where you can submit issue. Maybe there is one for the extension as well.

    I should add that I have not used this tool myself.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.