Restoring bacpac file to SQL Server 2014 results in SQL72014 error

Question

I am trying to import an Azure SQL export file ( .bacpac) into my local database and get the following error.

Powershell Team

PS C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin> .\SqlPackage.exe /a:import /sf:C:\SQLDATA\Backups\test-
2015-9-10-12-10.bacpac /tdn:test-live-local /tsn:.\sql2014

Error message below

Database import error: failed to import package.

Error SQL72014: .Net SqlClient Data Provider:

Msg 547, Level 16, State 0, Line 3
Restriction ALTER FOREIGN KEY "FK_CompanyPeopleCompany". The conflict occurred in the database "dbo.Companies", in the column "Id".

Error SQL72045: Script runtime error. Executed script: PRINT N'Checking constraint: FK_CompanyPeopleCompany [dbo]. [CompanyPeoples] '; ALTER TABLE [dbo]. [CompanyPeoples] WITH CHECK CHECK CHECK [FK_CompanyPeopleCompany];

.

.

Answer 1

bacpac, ( )? , bacpac . , bacpac . bacpac Azure ( ), .