Azure SQL Server import from bacpac leaves enforce foreign key constraints unchecked

Chris Gilliam 1

Hi,

I use the export data tier application and bacpac files to make a copy of my production database for development purposes. However when I import the bacpac file all the foreign key constraints are set to 'enforce =no" . What is the best way to make a copy of a database with all foreign key restraints still enforced ?

Anurag Sharma 17,616 Reputation points

2021-08-31T10:14:09.463+00:00

Hi @Chris Gilliam , welcome to Microsoft Q&A forum.

I tried the same using SSMS by generating the bacpac file of Azure SQL Db and then importing in to the on-premise SQL Server and the foreign key constraints were intact. Please check the below screenshot:

Could you please let us know how are you generating the bacpac and are you importing it in on-premise or Azure SQL Db only?

Also if you want to create a copy in Azure SQL database only, we have the copy option available as mentioned below:
Anurag Sharma 17,616 Reputation points

2021-09-02T06:42:30.077+00:00

Hi @Chris Gilliam , could you please check the previous response and let us know accordingly.

Share via

Azure SQL Server import from bacpac leaves enforce foreign key constraints unchecked

Your answer