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

Hi, Have you followed these steps

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

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,093 Most Valuable Professional on at

Like (0)

Report

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