Is SQL Managed Instance no longer compatible with SSDT Schema compare?

Tim Eldridge 206

As of the last few days, I am no longer able to do SQL schema compare for a database in SQL Managed Instance in Visual Studio using SQL Server Data Tools. This was working last week but now I get the error "Source is unavailable: dbname". After manually editing the .scmp file to tweak the connection string, I get a slightly different error "unable to determine database platform type". When I setup the source/destination connection it can connect to the SQL Managed instance OK using Azure AD - I know this because I get a list of databases in the "Default database" dropdown. However, when I click the "Compare" button to do the actual compare I get the error.

This functionality is still working when connecting to Azure SQL Database, but not Azure SQL Managed Instance. Is the latest SQL Managed instance version (Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 25 2022 16:04:35)) no longer compatible with SSDT?

Dan Guzman 9,411 Reputation points

2022-03-23T13:26:42.947+00:00

@Tim Eldridge , what values does your MI return for SELECT SERVERPROPERTY(N'Edition'), SERVERPROPERTY(N'EngineEdition');?
Tim Eldridge 206 Reputation points

2022-03-23T13:28:11.7+00:00

Edition = "SQL Azure" and EngineEdition = 8

Dan Guzman 9,411

I captured these queries at the start of SSDT schema compare so I was curious as to whether something changed as a result of the upgrade.

SELECT CASE WHEN SERVERPROPERTY(N'Edition') In ('SQL Data Services', 'SQL Azure') OR SERVERPROPERTY(N'EngineEdition') In (5, 6) THEN 'true' ELSE 'false' END
go
SELECT CASE WHEN SERVERPROPERTY(N'EngineEdition') = 6 THEN 'true' ELSE 'false' END
go

YufeiShao-msft 7,151 Reputation points

2022-03-24T08:42:51.287+00:00

In general, this situation is caused by a mismatch in SQL Server version, there's no SSDT standalone installer for Visual Studio , try to upgrade VS with SQL Tools extension
jiexin zhou 26 Reputation points

2022-03-24T09:58:47.85+00:00

We have the same issue on VS 2019 with SSDT 16.0.62111.25150
Butler Jonathan 61 Reputation points

2022-03-24T10:34:14.947+00:00
Hello

Same problem, SSDT Schema Compare working OK previously now cannot connect to Managed Instances, On-Prem is OK (SQL 2016-2019).

Is this helping us transition to the cloud? No

Does this increase risk of failure if we cannot develop for cloud database? Certainly, YES.

Should the interface provide feedback when the connections aren't working properly? YES.

(upload image not working, drag & drop or upload)

After clicking Schema Compare -> select target -> select connection; sometimes the databases will list from the MI other times they won't, in either case the dialogue remains greyed out as if the connection has failed. If a previously connection to another server is listed that one is used in the dialogue and not the instance chosen (but failed silently).

SSDT 16.0.62111.25150

VS Ent 16.11.10

This needs to be and must be better.

We can't have our development projects crippled by functionality failing because the cloud has been updated.

How about some info in the Visual Studio window if VS does need updating (trying that next - not trivial when I have to create update images first because it's so large to distribute!).

Thanks
Jonathan
Butler Jonathan 61 Reputation points

2022-03-24T10:40:02.297+00:00

Hello YufeiShao-MSFT

Please see my comment below regarding this functionality break for SSDT (due to cloud update?).

Do I need to raise a Microsoft support call for a resolution response time, i.e. is this a MI fix or SSDT fix (don't hold your breath).

This is a breaking [change] for our environment and deployment pipeline process.

Please could you offer guidance/reassurance/help to fix and timings?

Thanks
Jonathan
Tim Eldridge 206 Reputation points

2022-03-24T10:46:53.043+00:00

Hello YufeiShao-MSFT

I installed VS 2022 community edition with the latest version of SQL Server data tools yesterday and the issue still occurs. I agree with ButlerJonathan-2222 - this has broken development and deployment processes for a large number of people/teams and it needs an urgent fix. I think the fix is an update to SSDT to support the latest version of SQL MI

Thanks

Tim
YufeiShao-msft 7,151 Reputation points

2022-03-25T02:15:20.08+00:00

This is a feedback site with suggestions for submitting questions:https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0
Butler Jonathan 61 Reputation points

2022-03-25T08:41:33.217+00:00

You have got to be joking.

Microsoft break Visual Studio SSDT projects as a development pipeline and you want us to ask for the feature returning?

I think the cat is out of the bag. Microsoft is not a reliable partner. I'm now looking at other products and tooling where support is a priority.

I haven't heard back from the support call yet but I'll update here and on the feedback I raised through VS yesterday (link below to upvote).

Utter shambles and a disgraceful response so far.

Upvote the feedback to get some action on this utter shambles: https://developercommunity.visualstudio.com/t/Is-SSDT-Schema-Compare-broken-for-Azure/1702437

Thanks
Jonathan
Butler Jonathan 61 Reputation points

2022-03-25T08:48:50.123+00:00

Also, can as many people who are able to, please upvote this issue (please all who are following the problem? we are at 14 votes with 32 following updates).

Many Thanks
van Heerde, Jered 11 Reputation points

2022-04-05T07:28:53.907+00:00

I have raised a ticket with MS. This was the response:

I have looked internally and realized that new version of MI (code package 16.0.41.326) is making it impossible for customers to use SSDT/Visual Studio with their managed instances. However rest assured, PG teams from Visual Studio and Managed Instances are working on the fix. Changes will first become widely available to our customers in VS 17.2 preview 3, which is scheduled to release on April 12th.

In the meantime, a quick workaround is to downgrade the MI version and then test it, for which I am now raising a case with our Product team and let you know on the progress soon.

I'm still waiting on the rollback and currently on versions :
SQL Azure 8
Microsoft Visual Studio Enterprise 2019: Version 16.7.3
SQL Server Data Tools 16.0.62008.03130
Harmen Verburg 1 Reputation point

2022-04-05T18:29:23.02+00:00

Any idea when this will be fixed? Releasing our SQL database is becoming incredibly difficult now.
van Heerde, Jered 11 Reputation points

2022-04-06T09:39:28.56+00:00

after the roll back on managed instance i can now confirm SSDT Schema compare is working again. MS confirmed a new release of SSDT is required (no ETA yet)

I would suggest to create a support ticket if you want to have this fixed prior to release of a new version of SSDT
Butler Jonathan 61 Reputation points

2022-04-06T10:46:45.71+00:00

Hi

The short answer is that if you want to get Visual Studio working (Server Explorer, SSDT) with the Managed Instances then you need to raise a support call.

The fix is supposed to be released in VS 2022 17.3 available here - i haven't tried it yet.

But i need 2019.......can't find any update to that yet..

https://learn.microsoft.com/en-gb/visualstudio/releases/2022/release-notes#17.1.3

Good luck.......with Microsoft you'll need it.

JB
van Heerde, Jered 11 Reputation points

2022-04-06T13:58:28.987+00:00

feedback from ticket on the ETA:

I have checked with PG about the ETA on the fix and they mentioned that VS update with a fix should be released on April 12th.
Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator

2022-04-25T21:56:29.913+00:00

The fix for this issue is available in Visual Studio 2022 Preview (Version 17.2.0 Preview 3.0).
As short-term mitigation we suggest customers install Visual Studio 2022 Preview. This version can be installed side-by-side with other versions, and can be downloaded from https://visualstudio.microsoft.com/vs/preview/#download-preview
As a long-term mitigation, once the fix reaches the Visual Studio 2022 GA editions (version 17.2.0 or higher), we suggest customers start using Visual Studio 2022 GA (Community, Professional, Enterprise). There is currently no ETA for this fix to reach Visual Studio 2019.
Note that the use of Visual Studio 2022 Community is permitted for organizations of any size when used for SQL Server Data Tools development (the software license terms is available at https://visualstudio.microsoft.com/license-terms/vs2022-ga-community/).
Visual Studio (GA) can be downloaded from https://visualstudio.microsoft.com/downloads/

We apologize for the impact to affected customers. We are continuously taking steps to improve the Microsoft Azure Platform and our processes to help ensure such incidents do not occur in the future

Regards,
Oury
Ilkka Ellilä 1 Reputation point

2022-05-18T08:11:44.457+00:00

https://learn.microsoft.com/en-us/visualstudio/releases/2019/release-notes#release-notes-icon-visual-studio-2019-version-161115

The fix is here for the VS2019
اخلاص وردى ايوب نصير 1 Reputation point

2022-06-01T09:21:23.797+00:00

THANKS

19 answers

Lesinski, Martin 31 Reputation points

2022-04-04T07:09:27.08+00:00

Hi everyone,

Supposedly, this was fixed by Microsoft as part of 17.1.3

Is it working for anyone now? Because it still gives me an error message "wrong platform detected".
Would love to hear from others.
Please sign in to rate this answer.
Tim Eldridge 206 Reputation points

2022-04-04T07:24:32.557+00:00

Hi LesinskiMartin-8441

I have also installed Visual Studio 2022 Version 17.1.3 and am still getting the same original error "Source is unavailable: XXX" so this definitely hasn't fixed the issue for me. I wonder if it also depends on an update to the SQL Managed instance too?

Lesinski, Martin 31 Reputation points

2022-04-04T07:33:11.437+00:00

Ugh, terrible. To me the most confusing thing is that @Andrew Duckers has raised a ticket with Microsoft 9 days ago and said that it works for him after Microsoft said, that we issue is "mitigated". What is that all about?

Tim Eldridge 206 Reputation points

2022-04-04T07:48:25.223+00:00

Unless his SQL Managed Instance has been rolled back to a previous version?

Mark Poynter 26 Reputation points

2022-04-04T10:31:47.873+00:00

Same issue here - upgraded to 17.1.3 and get Target is unavailable (as I'm comparing it the other way round).

On the bright side the Data Comparison tool in VS 2022 is now working again.

Tobias Moesgaard Leth 1 Reputation point

2022-04-07T04:42:18.52+00:00

The fix in 17.1.3 does not correct the schema compare issue. This is a slightly different issue which Microsoft hope to have ready for the next 17.2 preview.
https://developercommunity.visualstudio.com/t/Is-SSDT-Schema-Compare-broken-for-Azure-/1702437#T-N10007078

Only solution so far is to roll back the Managed Instance version
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Vitor Tomaz 6 Reputation points Microsoft Employee

2022-04-14T19:23:47.807+00:00

The fix for this issue is available in Visual Studio 2022 Preview (Version 17.2.0 Preview 3.0)
https://visualstudio.microsoft.com/vs/preview/#download-preview
Please sign in to rate this answer.
Butler Jonathan 61 Reputation points

2022-04-14T20:21:34.893+00:00

Hi vitomaz

We were told earlier today that the VS Preview 3 is the fix to this problem.

We were on VS 2019 and they have NO FIX date for this.

So we have had to move to VS 2022 Preview.

I have asked about the preview statement that precludes use for production environments and how this applies when Microsoft have broken our dev/test/prod pipelines...I'll update when they get back to me.

I am not filled with confidence because
a) Microsoft broke our SSDT to Managed Instance development
and
b) MS don't think they have to fix the tooling people were using before MS broke it.
c) there is no GA fix available on any VS tooling for this (and the related tooling connections in VS are also broken - object explorer, server explorer).

Regards
Jonathan
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Carlo Lodola 11 Reputation points

2022-04-23T20:08:22.267+00:00

I am having this issue since Friday Apr 15 , posted on here 3 days ago , was told by Microsoft none of their customers are having this issue

Unfortunately work runs Windows 10, tried to install Vs 2022 but said OS doesn't support it

Anybody know if red gates SQL tool belt is still working?

https://learn.microsoft.com/en-us/answers/questions/819752/ssdt-20172019-will-not-connect-to-azure-managed-sq.html
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Carlo Lodola 11 Reputation points

2022-06-01T09:41:45.117+00:00

Working
SSDT 2017 Microsoft SQL Server Data Tools for Visual Studio 2017 (SSDT) Version 15.9.47

SQL Server Data Tools 15.1.62002.01090
Microsoft SQL Server Data Tools
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Is SQL Managed Instance no longer compatible with SSDT Schema compare?

19 answers

Your answer