Am using Sqlpackage.exe for to deploy my latest .dacpac into the SynapseSql using this command:
sqlpackage /Action:Publish /SourceFile:test.dacpac /p:DropObjectsNotInSource=TRUE /p:ExcludeObjectTypes="Permissions;Users;RoleMembership;Logins;ServerRoles;ServerRoleMembership;ExternalDataSources" /TargetConnectionString:"***********"
The deployment worksout, but all external tables are always dropped and recreated:
The dropped and recreated external table looks exactly same.
This issue if dropping / recreating has been fixed with release 162.0.52 of SqlPackage:
Source: https://learn.microsoft.com/en-us/sql/tools/sqlpackage/release-notes-sqlpackage?view=sql-server-ver16#162052-sqlpackage
Any idea, who the dropping and recreation of external table still occurs (am using version 162.0.52)?