Importing data into microsoft dynamics AX

The way one can import data into microsoft dynamics ax from a .dat file is

1. Navigation Pane->administrator-> periodic-> import data

2. then selecting the dat file to capture the data into AX.

3. Once the .dat file is loaded we can make a batch job to update the table or else we can do it manually as well.

But if the data is huge it will take forever to load the data because it does all the validations for each data while uploading it.But there is a fix.

Note: Before following these steps make sure you have your database backed up because this steps overwrite the existing data

->unzip and keep the data into one of the drives(c:)

-> once you have the .dat file then open Microsoft SQL Server Management Studio

-> In the Object explorer window select the database for AX.

-> Right click the database and select Restore Database

-> in Select Page window select General menu

-> On the source for restore, select the radio button From device:

-> By clicking on the browse button to the right of the option , give the path of the .bat file.

-> Your database will get listed at the bottom of the screen

-> Select the Options menu on the Select a Page tab again(near General menu)

->one the page select overwrite existing data check box

-> and click OK

It will take few minutes to load the data directly into the database, once it is complete you can start the AOS services again.