Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Schema Compare failed: The source and target platform must be the same to use Schema Compare for Azure Synapse Dedicated SQL Pool #20363

Closed
monteholyfield opened this issue Aug 16, 2022 · 2 comments · Fixed by #20558

Comments

@monteholyfield
Copy link

monteholyfield commented Aug 16, 2022

Azure Data Studio Version: 1.38.0 (user setup)
Commit: dff93c4
Date: 2022-07-26T23:56:16.217Z
VS Code: 1.62.0
Electron: 13.6.6
Chrome: 91.0.4472.164
Node.js: 14.16.0
V8: 9.1.269.39-electron.0
OS: Windows_NT x64 10.0.22000

Steps to Reproduce:

  1. create connection to Azure Synapse SQL Pool
  2. choose 'Create project from database'
  3. commit
  4. choose 'Update project from database' which produces the following error:

Schema Compare failed: The source and target platform must be the same to use Schema Compare for Azure Synapse Dedicated SQL Pool

Does this issue occur when all extensions are disabled?: Yes/No

@dzsquared
Copy link
Contributor

In the .sqlproj file for that project - what is the value in the tag?

@kisantia
Copy link
Contributor

@monteholyfield please check if this is the DSP in the sqlproj:
<DSP>Microsoft.Data.Tools.Schema.Sql.SqlDwDatabaseSchemaProvider</DSP>

The project's target platform can also be seen by right clicking on the project node and selecting "Change target platform", which will open this quickpick where the current target platform is displayed and can be changed
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment