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

Chris Gilliam 1 Reputation point
2021-08-31T07:00:38.317+00:00

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 ?

Azure SQL Database
{count} votes