Azure SQL Database
An Azure relational database service.
5,444 questions
Azure SQL Server import from bacpac leaves enforce foreign key constraints unchecked
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 53%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Chris Gilliam
1
Reputation point
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 ?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma 17,591 Reputation points2021-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,591 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.
Sign in to comment