How to export database from dev environment to .bacpac file?

(0) Share

Report

Posted on by Shooowtek

843

Hello,

I am trying to export a database from a development environment to a .bacpac file. I am using MSSMS =>AxDB=>Task=>Export Data-tier Application for this.
Unfortunately, I get the following errors every time:

One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71627: The element User: [NT AUTHORITY\NETWORK SERVICE] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
Error SQL71627: The element Login: [NT AUTHORITY\NETWORK SERVICE] has property IsMappedToWindowsLogin set to a value that is not supported in Microsoft Azure SQL Database v12.
(Microsoft.SqlServer.Dac)

SQL Server Management Studio 19.0.2

Could someone please help?

Thanks.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, Have you followed these steps

https://wp.me/p4lZK1-6I

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,190 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello Shooowtek,

I am used to importing a .bacpac file not exporting.

To resolve the issue, kindly delete the user with the login error and retry.

himmatsinghdulawat.blogspot.com/.../sitecore-database-principal-owns-schema-cannot-be-dropped-message.html

Was this reply helpful? Yes No