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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Import data from anoth...
Microsoft Dynamics AX (Archived)

Import data from another instance

(0) ShareShare
ReportReport
Posted on by manikumar 1,623

Hi all,

https://technet.microsoft.com/en-us/library/aa834324.aspx

i tried this many time, and both live n test server are taking too much time,. even one complete night not enough finish, is there any other way to import/export?

Thanks

*This post is locked for comments

I have the same question (0)
  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    What kind of data you want to being from old system?

    All data or specific?

  • manikumar Profile Picture
    manikumar 1,623 on at

    i want to import the company data to a fresh instance in office

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    1. How many number of companies in Old environment and how many you want from those to new environment

    2. you want to take only Steup+MasterDate or Setup+Master+Transactional data as well

  • Verified answer
    Mallika Roy Profile Picture
    Mallika Roy 552 on at

    Try this:

    blogs.bojensen.eu/.../how-to-copy-configuration-and-setup-data-from-one-environment-to-another-environment-in-microsoft-dynamics-ax-2012

    I was successful.

    Thanks.

  • manikumar Profile Picture
    manikumar 1,623 on at

    i said about this only, its never finished

  • manikumar Profile Picture
    manikumar 1,623 on at

    it was taking time at exporting EVENTINBOXDATA etc, so i cleaned these tables and succeeded with exporting. now when i importing dat into another new instance, its not showing any vendors/customer's data in ax. any help?

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    DAT company usually have no data for entities such as customers and vendors. This company is pre-created for purpose of metadata only or for initialization of system. This company is not used for transactional/ operational purpose

    If you want to transfer transactional data of a one company, you should go for that company only. DAT company is automatically created with new installation of AX.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    Apologies, I think you are not talking about DAT company. you are talking about Data. possibly typing Mistake from you.

    anyways, are you able to see data inside CustTable and VendTable from AOT?

    Are you able to see data in SQL Server by writing a query select * from CustTable?

  • manikumar Profile Picture
    manikumar 1,623 on at

    my mistake, Dat is .Dat file. and i imported to an instance(which has only Dat company only) . i did't find any difference in ax as well as in db. but is shown while importing like 999999 records in table (example). by doing this Company also will get import into new instance or i have to create everything?

    Thanks

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    Create a company with same 4 or 3 chars of DataArreaId in your new environment

    and then import data in your new environment.

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!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans