-
Notifications
You must be signed in to change notification settings - Fork 25
Description
- SqlPackage or DacFx Version: latest
- .NET Framework (Windows-only) or .NET Core:
- Environment (local platform and source/target platforms):
Steps to Reproduce:
- 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. - 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)