web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Data migration between different versions DEV environments

(0) ShareShare
ReportReport
Posted on by

Hello all,

What is the optimal approach and method/tools to migrate all business data from D365FO older version 10.0.8 to brand-new 10.0.16 DEV environment?

(*) By all business data I mean that environment related data, i.e. Users table, etc., should not be migrated.

I have the same question (0)
  • Verified answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    Since you're moving the data to a newer version, you should be able to simply restore the backup of the 10.0.8 database into your 10.0.16 system and run database sync.

    If you think about it, it's basically the same than what happens when you install MS updates to your system. The application gets updated, and then a database sync is performed against a database that was used by an older application.

    However since there's a big gap between 10.0.8 and 10.0.16 you might have issues - MS supports only skipping 3 updates in a row.

  • Community Member Profile Picture
    on at

    Thank you Nikolaos,

    What backup/restore method you suggest to use?

    (*) This is a DEV environments situation without BACKUP/RESTORE LCS options.

  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    SQL Server backup of AxDB database, which you take and restore using SQL Server Management Studio on the dev VM.

  • Community Member Profile Picture
    on at

    AxDB backup+restore will overwrite the target environment users table, and perhaps even more environment related data, right?

    How can I handle this, and exclude environment related data?

  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    Yes, that's the whole database.

    You can run Admin provisioning tool to make yourself the admin user again after restore. It's your dev system so I don't assume you need other users. If you do, you can import them.

    If you want to migrate only partial data, then you must export/import via data entities. This can be very time consuming, and I don't think you should do that in a dev system. Your dev system should be disposable, and you should be able to set up a new one quickly by deploying new system from LCS, restoring db template and getting latest code from source control.

    Your dev data template would usually come either from test system, or some centrally maintained golden config / golden dev data system.

    Anyway all this is beyond your original question which was about migrating data from older version system to a newer version. You can do that via db backup or data entities.

  • Community Member Profile Picture
    on at

    Thanks again.

    Last question on your original response:

    - "The application gets updated, and then a database sync is performed against a database that was used by an older application"

    How can I start the sync operation you mention?

  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    In that part I was talking about updating your existing system. Database sync happens automatically during the process.

    But when you copy a db from another system you must sync the db in the target system after you have restored the backup. You can do this via Visual Studio. It's also possible to run db sync via command line but since it's a dev system and you anyway use Visual Studio, that's the easiest way to do it. 

  • Community Member Profile Picture
    on at

    I tried the whole thing using normal SQL Server Backup/Restore, then ran Admin provisioning tool to make myself the admin user again.

    The process succeeded when both target and original databases were same Application version (both 10.0.16), but failed when the original was 10.0.8 and target was 10.0.16.

    @Nikolaos,

    Do you think that the DB sync you were talking about would solve this problem? And how can I use it specifically, i.e. from Visual Studio or Command line?

  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    Hi Yiannis,

    You must run db sync after restoring db from another system, regardless of version. In VS you find it in Dynamics 365 menu. You can ask from your dev team if you need help with it, every developer knows it since it's needed all the time. 

    You can also search the web or post a new question if you need help to run it. Searching the web is usually the quickest way to find answers to such questions. 

    So, please proceed with db sync and let us know how it goes. Thanks! 

  • Community Member Profile Picture
    on at

    Oh, I just got that you meant a Full database synchronization from Dynamics365 VS menu! :-))

    I just started it, and will let you know the result.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 464 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans