web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Community Member Profile Picture
    on at
    RE: Data migration between different versions DEV environments

    After playing with the data for some days, I can confirm that data were migrated correctly and everything works fine.

    Thanks again, Nikolaos!

  • Community Member Profile Picture
    on at
    RE: Data migration between different versions DEV environments

    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.

  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at
    RE: Data migration between different versions DEV environments

    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
    RE: Data migration between different versions DEV environments

    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
    RE: Data migration between different versions DEV environments

    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
    RE: Data migration between different versions DEV environments

    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
    RE: Data migration between different versions DEV environments

    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
    RE: Data migration between different versions DEV environments

    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
    RE: Data migration between different versions DEV environments

    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
    RE: Data migration between different versions DEV environments

    Thank you Nikolaos,

    What backup/restore method you suggest to use?

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

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 882 User Group Leader

#2
André Arnaud de Calavon Profile Picture

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

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 518

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans