Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by 737

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.

  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 12,759 Most Valuable Professional on at
    RE: How to export database from dev environment to .bacpac file?

    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

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: How to export database from dev environment to .bacpac file?

    Hi, Have you followed  these steps

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans