How to import data of a client into a company in Dynamics AX

1. Get Microsoft SQL Server installed in your PC.
2.  Get the backup of Database of the client and import it to Microsoft SQL Server Management Studio.

3. Create a new Database, then click
 Database > Tasks > Import Data...
4. then you have to export tables into excel format 
click  Database > Tasks > Export Data...
then choose SQL native client as a Datasource.
 click next and then choose Microsoft Excel as a 
a DataSource.


5. click next then chhose the table you want to export and clich finish.
Now, you have the table exported in Excel Format.
Save it in CSV format to import the data to AX.














6. To import Data to DAX, we will use CSV format.
And then we use a job to import Data needed from CSV file to tables of DAX.

7. if you want to update from a table in DAX

Note
When you use the query select you don't have to use transactions : ttsbegin; and ttscommit , but you have to use that in case of delete or update queries.