SQL Server Data Import Wizard

(0) Share

Report

Posted on by dhamacher

115

Hi,

I want to import data from specific tables from an AX test environment to my AX local environment. The reason I want to do this is to debug on my local machine using the data QA is using for testing. The easiest solution would be to use SQL Server and select the tables I want to import. But then I was thinking about the RecId. Using SQL Server import I assume that I also import the RecId from the testing environment, will that mess up my local database? What if those RecId already exist somewhere else? Is that even possible? What would you recommend here?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report
Importing data directly from SQL server is not a healthy idea. One major reason you mentioned yourself. Other major reasons are e.g. relationships using ReCId(s).

There can be two feasible ways here.

Use DIIXF

Using DIXF you can create queries inside AX and if both Server1 and Server2 are both on same domain you can create a direct communication between those by ODBC Connection, using DIXF.

You can also connect DIXF with an SQL box directly.

Proceeding same way as you are thinking now.

Think of if number are tables are very limited and there are no relationships based on RecId(s).

Bring data from source system and import in on destination SQL Box, by creating a new table outside AX DB. Now go inside AX. Write ODBC connection and connect to table which has your data. Write code to read data using ODBC and create records in AX .create()

If I were in your shoes, I will prefer #1, i.e. Using DIXF

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

Do you have any reason not to use Test Data Transfer Tool?

You definitely shouldn't manipulate database directly; I can think of several more problems with it...

Was this reply helpful? Yes No
dhamacher 115 on at

Like (0)

Report

Awesome response Sohaib. Only catch is that we are on CU6 which does not include the export/import framework so I guess that option 2 is the only one for now. I tested the ODBC solution and it worked, I love it!

Was this reply helpful? Yes No
dhamacher 115 on at

Like (0)

Report

The reason I am not using it is because I didn't know that it exists. Now I do! Thank you Martin.

Was this reply helpful? Yes No
Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

Note that you can install DIXF to any version of AX 2012 (although upgrading to a version that isn't three years old may be a better approach).

Was this reply helpful? Yes No
dhamacher 115 on at

Like (0)

Report

You're right, but my hands are tied by management in terms of installing new tools. I have discussed the advantages towards an upgrade (which is desperately needed) but it seems that it will take couple more years maybe!?

Was this reply helpful? Yes No
Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

I feel your pain, bro. :-)

Was this reply helpful? Yes No
dhamacher 115 on at

Like (0)

Report

I assumed you would ;)

Was this reply helpful? Yes No

Community site session details

SQL Server Data Import Wizard

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

SQL Server Data Import Wizard

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates