Move sandbox database to VM

(3) Share

Report

Posted on by CU03091226-0

115

If I want to move the data i have on the sandbox into my virtual machine is it as simple as exporting the data from LCS and then uploading it inside my VM through SSMS as shown in this tutorial:
https://community.dynamics.com/blogs/post/?postid=19efe83c-afab-437b-be79-341dcebf3f4a

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (0)

Report

Hi,

Partially, you should avoid using SSMS to import .bacpac files, and instead use SQLPackage.

D365FO.Toolbox contains a really good wrapper for it, that makes it easy to use: How To Import Bacpac Into Tier1 · d365collaborative/d365fo.tools Wiki (github.com)

Was this reply helpful? Yes No
CU03091226-0 115 on at

Like (0)

Report

Do we require a connection to the database if i want to create a deployment package? If i wan to create a deployable package from a VM which is not related to the same project which is on LCS, will there be any issues or is the deployment package not related to the database.

Was this reply helpful? Yes No
Verified answer

Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (0)

Report

No, it's two separate systems. The deployable package is not related to the database.

Just out of curiosity, what do want to do? Ideally, if it's not for demo or training, deployable packages should not be generated from a development VM but from Azure DevOps or GitHub.

Was this reply helpful? Yes No
CU03091226-0 115 on at

Like (0)

Report

You mean generating the deployment package from Azure DevOps through the pipelines correct? But how would you be able to do that from Github?

Was this reply helpful? Yes No
Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (0)

Report

Yes, exactly. I have used Azure DevOps for all of my (former) customers.

It's possible to use GitHub using FSC-PS and I'm using it for some of my private projects. It's not supported by Microsoft so your mileage may vary .

fscpscollaborative/fscps: D365 FSC DevOps setup&maintenance tools for GitHub

Was this reply helpful? Yes No
CU03091226-0 115 on at

Like (0)

Report

Noted. Can you please explain a bit more why it is not ideal to generate the deployment packages from the VM?

Was this reply helpful? Yes No
Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (0)

Report

The problem for me / us is that we loose traceability of what comes into our systems, and how it was deployed. I.e. we cannot see the code that got compiled into the binary, the compiler that was used and what F&O artifacts was downloaded, the configuration of the build/deployment pipelines, logs of the build and so on. So It's a major risk factor.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Move sandbox database to VM

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Move sandbox database to VM

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates