Export database of UAT to Development SQL Error in D365

(0) Share

Report

Posted on by Rhushikesh R

758

Hi Everyone,

I was trying to export UAT database to Development environment.

I downloaded the .bacpac file from LCS library and followed steps from below blog,

www.cloudfronts.com/.../

But now facing below error,

Kindly request you to help me to resolve this issue as soon as possible.

My development has been stuck due to this issue.

Thank you in advance,

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

Try to follow documentation and import it using SqlPackage.exe https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/dbmovement-scenario-exportuat#import-the-database

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report
Copy link

Link copied!

Hi ievgen,

Thanks for help.

I followed the standard blog.

In first step it has been written that

To ensure the best performance, copy the *.bacpac file to the local computer that you're importing from. Download sqlpackage .NET Core for Windows from Get sqlpackage .NET Core for Windows. Open a Command Prompt window, and run the following commands from the sqlpackage .NET Core folder.

But I do not have admin rights to install this sqlpackage.

Could you please tell me how can I proceed?

Was this reply helpful? Yes No
Verified answer

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

It does not require any installation, you just download it and extract from the archive, then cd to the folder and run import command. So what did you try to install and how ?

You need to follow these steps https://docs.microsoft.com/en-gb/sql/tools/sqlpackage-download?view=sql-server-ver15#get-sqlpackage-net-core-for-windows, no installation mentioned there

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report
Copy link

Link copied!

Thanks ievegen,

Actually I was checking for Get sqlpackage for Windows instead of Get sqlpackage .NET Core for Windows.

Thanks a lot. Your reply helped me a lot.

Was this reply helpful? Yes No