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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

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

(0) ShareShare
ReportReport
Posted on by 518

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

I have the same question (0)
  • Suggested answer
    Sergei Minozhenko Profile Picture
    23,093 on at

    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.

  • Suggested answer
    A.Prasanna Profile Picture
    8,223 on at

    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 )

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 545 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 408

#3
Adis Profile Picture

Adis 267 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans