Data Migration in Microsoft Dynamics AX 2012 R3

(0) Share

Report

Posted on by Community Member

Hi all, (English isn’t my first language, so please excuse any mistakes !)

I have a question about data migration ax 2012. If i have server with database about "sales order" (let's call it server A) and another server with database of dynamics ax 2012 r3 (call its server B)

And now i want to get all data "sales order" in server A and put its in server B(dynamics ax) and make sure its goes to exactly "sales order" in dynamics ax

How i can do that ?

Thanks all very much !

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (1)

Sohaib Cheema 48,650 User Group Leader on at

Like (1)

Report

RE: Data Migration in Microsoft Dynamics AX 2012 R3

Let me add here little more, either you go by DMF or by X++, you need to take care of few points.

Main point to be considered before all of process, is to make sure both systems have same Master data. If I am going to create a SalesLine, both the servers should have same inventory or at least the items for which I am going to create order lines. Another example can be taken of Sales Category. Both systems should have same sales categories, in case if you are using non-inventory items in your sales. So, before running this specific DMF jobs, which we are discussing, you should also run a job which should synch your master data such as inventory, Customer Master and procurement categories,

In fact, you can add multiple Entities under same Definition group. All will be executed in order

Seems a full time integration job

Was this reply helpful? Yes No
Sohaib Cheema 48,650 User Group Leader on at

Like (0)

Report

RE: Data Migration in Microsoft Dynamics AX 2012 R3

yes

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Data Migration in Microsoft Dynamics AX 2012 R3

So i can use DMF to automatic import data from another server into AX server SalesTable and SaleLine ?

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 48,650 User Group Leader on at

Like (1)

Report

RE: Data Migration in Microsoft Dynamics AX 2012 R3

you can do this without customization/x++ as well

1)SQL server allows you to create a query to select data of today

2) servers allows you to create ODBC connection

3) DMF can accept a ODBC connection and a SQL query

4) DMF can also allow you run periodically the job

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Data Migration in Microsoft Dynamics AX 2012 R3

Hi Sohaib,

Sorry for my question not clearly !

Just like you wrote above, i want process periodically by time/date (all the records will insert into AX table in the end of the day).

Was this reply helpful? Yes No
Sohaib Cheema 48,650 User Group Leader on at

Like (1)

Report

RE: Data Migration in Microsoft Dynamics AX 2012 R3

if you want to follow you own way, you should have started your question in different way. the question gives an impression of asking suggestion about ways of importing data from one server to other.

anyway, now if you are following your own way to do this job, you may clarify for us, what do you want actually, why you want to use batch job? do you want this process to happen periodically? DMF Also allows you to run jobs periodically. if you wan to run it periodically, what is your point controlling "last synched value" i.e. last synch/read created how many records and now today in next run how many records and which record should be fetched? why x++ is preferred choice for you here in this case?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Data Migration in Microsoft Dynamics AX 2012 R3

Thanks Sohaib !

But i want automatic get and insert data into server Dynamics AX, follow your link, i need to do some anothers setup to insert data.

All step :

1. I create query connect between 2 server A(sales order) and server B(ax 2012)

2. In server B have table(B_sales) that store data "sales order" from server A

3. Use X++ code (classes and bachjob) to automatic insert data from table (B_sales) into Dynamcics AX sales order.

(I follow this link :msdaxtech.blogspot.com/.../sales-order-and-purchase-order-tables.html).

And the 3 step make me confure, i still dont know how to do it ?

Was this reply helpful? Yes No
Daniele Ferraretto on at

Like (1)

Report

RE: Data Migration in Microsoft Dynamics AX 2012 R3

try it

simpleax.wordpress.com/.../read-data-from-another-ax-and-write-it-a-table-using-recordset-metadata

Was this reply helpful? Yes No
Sohaib Cheema 48,650 User Group Leader on at

Like (1)

Report

RE: Data Migration in Microsoft Dynamics AX 2012 R3

alright, in that case DMF can be best choice.

instead of wasting time to write x++ code, you may write a SQL query and connect your server B with server A using ODBC. Finally execute that query inside dmf

have a look at next blog post

shafeaa.blogspot.com/2015/09/ax-2012-import-data-from-odbc-through.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Data Migration in Microsoft Dynamics AX 2012 R3

Hi Daniele,

I cannot log in into your website, can you send another ?

Was this reply helpful? Yes No