Skip to main content
Microsoft Dynamics AX forum
Suggested answer

Want to do data migration/ copy the data of live to the test server. How can i do that.

editSubscribe (0) ShareShare
ReportReport
Posted on by 502

Hello all,

Want to clown/copy the data of live server to the test server. That is all the data should be copied to the test server.

How can i do that.

Thank you

Siddhant Singh

Attachments
  • Suggested answer
    A.Prasanna Profile Picture
    A.Prasanna 8,131 on at
    RE: Want to do data migration/ copy the data of live to the test server. How can i do that.

    Which Version of AX you are using ?, if it is AX 2012 versions

    and your Environments within same domain easiest way to backup and then restore to the test server.

    even if your environments are in deterrent domains you can do same thing but you need to manually add users from SQL Table to grant access .

    Or Else you can use Test Data Transfer Tool to Export data and then you can use same tool for importing too.

    Thanks ,

    Amith Prasanna ,

    (Please mark answer as verified answer if this solved your issue )

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,081 on at
    RE: Want to do data migration/ copy the data of live to the test server. How can i do that.

    Hi Siddhant,

    You can make backups of business data database and modeldatabase from the live server and restore it with the test DB names to test DB server.

    Then you would need to update environment-specific data (integrations, e-mails, and so on) in restored DB to be sure that the test server will not start to interact with real business world.

    stackoverflow.com/.../ax-2012-restore-production-over-non-production

    But make backups first for test DBs to be sure that in case of issues you can restore original DBs.

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,126 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,646 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans