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)

Daniele Ferraretto on at

Like (1)

Report
Copy link

Link copied!

Hi IMHO you could use the DMF and setup entity for import data from A database to B database see the following link

technet.microsoft.com/.../dn507098.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Daniele, thanks for answer !

How about using X++ to get and insert data from A database to B database ?

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

are both servers in same network/domain ???

Was this reply helpful? Yes No
Daniele Ferraretto on at

Like (0)

Report
Copy link

Link copied!

I write something here

wordpress.com/.../923089417

take it as a suggestion : anyway try to use the DMF that's more standard and reliable.

Bye, Daniele.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sohaib,

Yes, both servers in same network and domain.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Daniele,

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

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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
Daniele Ferraretto on at

Like (1)

Report
Copy link

Link copied!

try it

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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