Table output not working when scripting from Azure SQL Data Warehouse

[merrillaldrich]

Scripting aborts when processing tables from Azure SQL Data Warehouse. No information about which object if any is the cause. I am using this command line in PowerShell:

mssql-scripter -S <server> -d <database> -U <user> -P <password> --script-create --file-path "$scriptoutputfolder" --target-server-version 'AzureDW' --exclude-use-database --include-types table --file-per-object --display-progress

and I get output like:

...
Scripting progress: Status: Progress Progress: 92 out of 126 objects scripted
Scripting progress: Status: Progress Progress: 92 out of 126 objects scripted
Scripting progress: Status: Progress Progress: 92 out of 126 objects scripted
Scripting request: 3fe33b8a-a875-4916-a52d-6a4e987ce7ad encountered error: An error occurred while scripting the objects.
Error details: Microsoft.SqlServer.Management.SqlScriptPublish.SqlScriptPublishException: An error occurred while scripting the objects. ---> Microsoft.SqlServer.Management.Smo.
UnsupportedVersionException: Either the object or one of its properties is not supported on the target server version.

   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ThrowIfBelowVersionLimit(SqlServerVersionInternal targetVersion, SqlServerVersionInternal upperLimit, String exceptionText)

   at Microsoft.SqlServer.Management.Smo.Index.ClusteredColumnstoreIndexScripter.Validate()

   at Microsoft.SqlServer.Management.Smo.Index.IndexScripter.GetCreateScript()

This is puzzling because my source and target versions/editions of SQL Server are the same - I just want a Data Warehouse script from Data Warehouse.

[MrMeemus]

@merrillaldrich what version of the tool do you have?

Our latest is 1.0.0a17, please update to that and see if it fixes your issue.

[merrillaldrich]

Hi - I had the xx.15 version, so I upgraded to the xx.17 version, using pip with --upgrade, but now it won't run at all. I get:

Scripting request: aecd4e34-239f-4eb0-99bc-67ff4a969934 encountered error: Must declare the scalar variable "@@servername".
Error details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@@servername".

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
...

(I know @@ServerName is illegal in Azure SQL Data Warehouse)

[MrMeemus]

@merrillaldrich, thanks for the help, this issue will be fixed in our next release.

[MrMeemus]

Fixed in #125, included in release 1.0.0a18.