We found the root cause...it was permissions issue. Used the /DiagnosticsFile:C:\Diag\diag.txt parameter with the SQLPackage command to generate diagnostic logs that indicated this: Error detected when reverse engineering the database. Severity:'Error' Prefix:'' Error Code:'0' Message:An error occurred while attempting to reverse engineer elements of type Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlDatabaseWorkloadGroup: Batch Command during reverse engineer failed with Error Code: -2146232060 Line Number: 1 Error Message: User does not have permission to perform this action.. Microsoft.Data.Tools.Diagnostics.Tracer Error: 19 : 2024-02-13T11:33:34 : Microsoft.SqlServer.Dac.DacServicesException: An error occurred during deployment plan generation. Deployment cannot continue. The error indicates that user account specified in the SQLPackage command is unable to create Schema objects. So, used the SQL Server Management Studio to see if the has rights to create a table in target DW DB and received permissions error while doing so. Assigned the user DBO rights on target DW DB and that resolved the problem.
Error SQL72018: SqlDatabaseWorkloadGroup could not be imported - SQLPackage.exe
Hi We're trying to move a Dedicated SQL Pool DB (DW DB) from one tenant to another using SQLPackage.exe. The extraction of the source DW DB completed successfully, however, when publishing / importing the same to target DW Server, we're seeing the following error: .\SqlPackage : *** An error occurred during deployment plan generation. Deployment cannot continue. At line:1 char:1 .\SqlPackage /Action:Publish /p:IgnorePermissions=True /SourceFile:de ... CategoryInfo : NotSpecified: (*** An error oc...annot continue.:String) , RemoteException FullyQualifiedErrorId : NativeCommandError Error SQL72018: SqlDatabaseWorkloadGroup could not be imported but one or more of these objects exist in your source. Errors occurred while modeling the target database. Deployment can not continue. I've checked the source and there's isn't any Workload Groups configured in the source. Any pointers please? Thanks Taranjeet Singh
check if 'SqlDatabaseWorkloadGroup' is supported in synapse database. Sometimes there might be features that are only available in sql databases and not in synapse database might cause errors.
Sign in to comment