Update-AzSqlSyncGroup : Long running operation failed with status 'BadRequest'.

Ashley Brinson 26 Reputation points
2022-08-26T03:23:53.423+00:00

Getting the following error when trying to update Schema for AzSqlSyncGroup:

Update-AzSqlSyncGroup : Long running operation failed with status 'BadRequest'.  
At <PATH> char:1  
+ Update-AzSqlSyncGroup `  
+ ~~~~~~~~~~~~~~~~~~~~~~~  
    + CategoryInfo          : CloseError: (:) [Update-AzSqlSyncGroup], CloudException  
    + FullyQualifiedErrorId : Microsoft.Azure.Commands.Sql.DataSync.Cmdlet.UpdateAzureSqlSyncGroup  

I am trying to update the schema for a Database Type: AzureSqlDatabase.

The command I am running is:

Update-AzSqlSyncGroup `  
    -Name $syncGroupName `  
    -ServerName $serverName `  
    -DatabaseName $databaseName `  
    -DatabaseCredential $credential `  
    -ResourceGroupName $resourceGroupName `  
    -SchemaFile $tempFile  
Azure SQL Database
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,624 questions
{count} vote

Accepted answer
  1. Alberto Morillo 34,461 Reputation points MVP
    2022-08-26T16:24:14.183+00:00

    You need to manually replicate schema changes as explained here.

    More details explained here.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.