You need to manually replicate schema changes as explained here.
More details explained here.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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