Clarification on Data Migration and Database Import

(1) Share

Report

Posted on by Raed Salah Bzour

111

Hi everyone,

I am setting up a new D365 F&O Dev VM and I have some confusion around the following points, I would appreciate it if someone could clarify:

1. What is the difference between Data Migration and Database Import?

2. If I create a new Dev VM, what exactly do I need to do to get my data into it?

3. What is the difference between importing a database from an old VM vs starting fresh without an old VM?

Please share detailed practical steps if possible, not just theory.

Thanks in advance!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Subra 1,011 on at

Like (1)

Report
Copy link

Link copied!

Hi @Raed Salah Bzour

Before answering into your question, could you please let us know where you want to get the data into your dev VM?

Usually, we will copy the data from Prod -> UAT -> Dev, for this we have set of different approach.

Was this reply helpful? Yes No
Raed Salah Bzour 111 on at

Like (0)

Report
Copy link

Link copied!

Hi Subra,

Thank you for your response!

I would like to understand all possible cases:

1. If the data is coming from an old Dev VM to a new Dev VM
2. If the data is coming from Production to a Dev VM

For each case, could you please walk me through the full flow step by step or give me blogs for the full flow? I am still learning and I want to understand the process from start to finish, not just the theory.

Thanks in advance!

Was this reply helpful? Yes No
Verified answer

Subra 1,011 on at

Like (0)

Report
Copy link

Link copied!

Hi @Raed Salah Bzour

Thanks for the clarification.

Please find the below information and I have attached a link as well for your reference.

1. We can copy DB using .Bak file and this can be done using SSMS.
2. Please restore the data from Prod to sandbox first. once it's done. please take a backup from sandboax and restore the same in your dev environment using script.

Restore from Prod to dev

https://www.linkedin.com/pulse/restore-production-database-dev-environment-d365fo-using-abbas-tfwbe

Restore from old dev to new dev vm (Refer Create backup and restore backup)

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/quickstart-backup-restore-database?view=sql-server-ver17&tabs=ssms

Kindly let me know if you need any need further clarifications.

Thanks,
Subra

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No