CODEWITHSUNDEEP
dacpacsqlpackagedata-tier-applicationsazure-synapse
ASHISH M.G
ASHISH M.G

Reputation: 802

DACPAC error if External tables and data sources present at source db

Getting the following error on DACPAC deployment to Azure Synapse SQL Pools:

Error SQL72018: SqlExternalDataSource could not be imported but one or more of these objects exist in your source.

This has started since my colleagues created couple of external data sources and external tables in the source database. Do we have any resolution for this ?

Upvotes: 0

Views: 869

Answers (1)

Utkarsh Pal
Utkarsh Pal

Reputation: 4544

With the given information it's not clear which tool you have used to create the dacpac.

With my own experience if you Import/Export dacpac using SQL Server Management Studio (SSMS), all your external tables and temporary files includes in dacpac.

You can refer my answer on this SO thread Move Azure SQL Database to new Azure Account on how to Export and Import databases using SSMS.

You can also refer this third-party tutorial: https://www.sqlshack.com/importing-a-bacpac-file-for-a-sql-database-using-ssms/

Upvotes: 0

Related Questions