Skip to content

Dropping external tables while there are no changes #249

@rkoumans

Description

@rkoumans
  • SqlPackage or DacFx Version: latest
  • .NET Framework (Windows-only) or .NET Core:
  • Environment (local platform and source/target platforms):

Steps to Reproduce:

  1. We release our database projects to Azure synapse through Azure Devops. In Azure Devops we use the 'Azure SQL Database deployment' task to do this. Since several weeks we notice that the deployment took much longer than before due to dropping every external table and re-create them while the are no changes made to the artifacts.
    When we do a deployment with the same publish script via Visual Studio the external tables won't be deleted.
  2. This is the "C:\Program Files\Microsoft SQL Server\160\DAC\bin\SqlPackage.exe" /Action:Publish /SourceFile:"D:\a\r1\a\Build Database Project\drop\Vebego Azure DWH\Database\bin\Output\Database.dacpac" /TargetServerName:"" /TargetDatabaseName:"" /TargetUser:"" /TargetPassword:"" /Profile:"D:\a\r1\a\Build Database Project\drop\Vebego Azure DWH\Database\Database.publish.xml" /Variables:AzureDataLakeStore= /Variables:AzureDatalakeCredential=* /Variables:Environment=***

Publishing to database '' on server ''.
2023-04-04T08:40:03.4840777Z Initializing deployment (Start)
2023-04-04T08:40:51.4451578Z Initializing deployment (Complete)
2023-04-04T08:40:51.4458409Z Analyzing deployment plan (Start)
2023-04-04T08:40:51.7479428Z Analyzing deployment plan (Complete)
2023-04-04T08:40:51.7487033Z Updating database (Start)
2023-04-04T08:40:53.0604585Z Dropping External Table [stg].[Capacityd_xxxxx]...
2023-04-04T08:40:53.2690632Z Dropping External Table [stg].[Capacityd_xxxxxx]...
2023-04-04T08:40:53.4003746Z Dropping External Table [stg].[Capacityd_xxxx]...
.....
2023-04-04T08:41:54.0152301Z Creating External Table [stg].[Capacityd_xxxxxx]...
2023-04-04T08:41:55.2132575Z Creating External Table [stg].[Capacityd_xxxxxx]...
2023-04-04T08:41:56.0955483Z Creating External Table [stg].[Capacityd_xxxxxx]...

Did this occur in prior versions? If not - which version(s) did it work in?
We noticed this since 23-02-2023
(DacFx/SqlPackage/SSMS/Azure Data Studio)

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions