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

SqlPackage Extract for Synapse Dedicated SQL Pool - throws error SQL73068: Unsupported collation 'Latin1_General_100_CI_AS_SC_UTF8' #370

Open
michalExt opened this issue Dec 5, 2023 · 0 comments
Labels
bug Something isn't working sqldw Issues related to SQL DW and/or Synapse

Comments

@michalExt
Copy link

michalExt commented Dec 5, 2023

  • SqlPackage or DacFx Version: 162.1.167.1
  • .NET Framework (Windows-only) or .NET Core: 7.0.401
  • Environment (local platform and source/target platforms): Windows 10 22H2

Steps to Reproduce:

  1. Running SqlPackage from PowerShell to export dedicated SQL Pool to storage container (SQL Pool using UTF8 collation: Latin1_General_100_CI_AS_SC_UTF8 )
    SqlPackage /Action:Extract /p:CompressionOption=NotCompressed /at:$access_token /SourceServerName:MY_SYNAPSE.sql.azuresynapse.net /SourceDatabaseName:MY_DedSQLPoolName /TargetFile:databaseschema.dacpac /p:AzureStorageBlobEndpoint=https://myBlob.blob.core.windows.net /p:AzureStorageContainer=myStorContainter /p:AzureStorageKey=myStorageKey

  2. Getting the error after many lines of 'Processing Table.... ' lines :

SqlPackage : *** Error extracting database:
At line:4 char:1
SqlPackage /Action:Extract /p:CompressionOption=NotCompressed /at:$ac ...

    CategoryInfo          : NotSpecified: (*** Error extracting database::String) [], RemoteException
    FullyQualifiedErrorId : NativeCommandError

Error SQL73068: Unsupported collation 'Latin1_General_100_CI_AS_SC_UTF8'.

And when run with /Diagnostic:true

Microsoft.Data.Tools.Diagnostics.Tracer Information: 25 : 2023-12-05T20:38:49 : Perf: Operation ended (name, details, elapsed in ms): Exporting data,,44793
Microsoft.Data.Tools.Diagnostics.Tracer Error: 19 : 2023-12-05T20:38:49 : Microsoft.SqlServer.Dac.DacServicesException: 
Error SQL73068: Unsupported collation 'Latin1_General_100_CI_AS_SC_UTF8'.

Microsoft.Data.Tools.Diagnostics.Tracer Information: 25 : 2023-12-05T20:38:49 : Perf: Operation ended (name, details, elapsed in ms): Extracting schema,,354159
SqlPackage : *** Error extracting database:
At line:4 char:1
SqlPackage /Action:Extract /Diagnostics:true /p:CompressionOption=Not ...

   CategoryInfo          : NotSpecified: (*** Error extracting database::String) [], RemoteException
   FullyQualifiedErrorId : NativeCommandError

Error SQL73068: Unsupported collation 'Latin1_General_100_CI_AS_SC_UTF8'.

Did this occur in prior versions? If not - which version(s) did it work in?
This is the first time I'm executing it.
(DacFx/SqlPackage/SSMS/Azure Data Studio)

@michalExt michalExt added the bug Something isn't working label Dec 5, 2023
@dzsquared dzsquared added the sqldw Issues related to SQL DW and/or Synapse label Feb 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working sqldw Issues related to SQL DW and/or Synapse
Projects
None yet
Development

No branches or pull requests

2 participants