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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Moving Master Data on ...
Finance forum

Moving Master Data on D365 between Production-UAT-Dev environments

(0) ShareShare
ReportReport
Posted on by MDeeb 94

Hi,

As far as i know i can refresh databases from Production to UAT through service request on LCS, but how can i move master data between the three environments? i have valid master data on Dev and need to move it to UAT, is there a way other than data management framework where i have to export and import each entity ?

Thank you,

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

    You can export / import the database: [View:https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/database/copy-database-from-sql-server-to-azure-sql]

    For subsets of data you have to use data entities.

  • MDeeb Profile Picture
    MDeeb 94 on at

    Thank you for your usual support Nikolaos,

    but how can I access my UAT database instance? when I run SSMS on UAT and try to connect to sql as per the sql instances names on LCS and credentials on LCS it gives network error, is there any prerequisite needed to access?

    Thank you,

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,166 Moderator on at

    You have to add ".database.windows.net" to the db server name that you see in LCS. You have to run SSMS on the UAT VM, and run it as administrator.

    If you see database info "foo/axdb" in LCS, the server name is foo.database.windows.net.

  • MDeeb Profile Picture
    MDeeb 94 on at

    Thanks a lot Nikolaos , I just tried it and it worked perfectly, my last question is can i export\ import databases between different D365 versions? I think I can not but I just want to make sure.

    I have UAT with Application version july update platform update 12 and Dev with application version 1611 platform update 15, i know it is a mess but I want to delete the dev environment and create new one with same UAT version, but can I restore the dev database to UAT in this case before I delete it ? or they need to be same versions?

    Thank you,

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,710 Moderator on at

    As far as I have seen databases with two different version does not work

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,166 Moderator on at

    You can do that but you have to do a data upgrade first.

    Data upgrade is needed when moving to a new application version (this will not be needed in future updates when updating from 8.0+ to later versions according to MS).

    [View:https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/migration-upgrade/upgrade-data-to-latest-update]

  • MDeeb Profile Picture
    MDeeb 94 on at

    Thanks a lot  Nikolaos for your helpful answers, really appreciated.

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans