Integrate AX 2009 with the SQL Server 2005 database

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Not Answered This post has 0 verified solutions | 1 Reply | 2 Followers

Not Ranked
1 Posts
10 Points
Joined: Feb 5, 2009
Last Online:
Jul 29, 2009 3:05
susya_11 posted on Jul 1, 2009 13:09
How helpful was this post/question? Please rate here:

Hi all,

Can anybody share Ur thoughts and help me with the following:

Our company has an application for tracking projects (phases, tasks etc) and related staff. It uses the SQL Server 2005 db. We are introducing AX 2009 and want to have old and AX database synchronized (with the corresponding mapping of course). Means that if I change smth from AX it should go to the old SQL Server db, and vice versa - if I do some change from application - It goes to AX.

Can't it be just db replication OR it should be some solution with business objects (like via BizTalk, AIF or business connectors). Please help with some details, links or tips.

- Thanks in advance

 

All Replies

Top 25 Contributor
Male
749 Posts
8,199 Points
Joined: Jan 21, 2003
Last Online:
Mar 19, 2010 11:43
Location: Herts, England
DynamicsAXMVP
Moderator
Harish Mohanbabu replied on Jul 2, 2009 18:43
How helpful was this comment/solution? Please rate here:

Hello,

susya_11:
Means that if I change smth from AX it should go to the old SQL Server db, and vice versa - if I do some change from application - It goes to AX.

I understand you want Ax to connect to two different databases based on some settings. 

Fundamentals first - 

 

  • If you look in DAX server configuration applet, that is where details like server name, database name etc are configured.  
  • Based on those settings, AOS server initiates and holds connection to database.
  • For Ax client to work, details like AOS name etc have to be provided in the client configuration applet.
  • When Ax client is started, based on the above settings client will connect to AOS.

 

Moving away from fundamentals, DAX as with any other ERP has a very close relationship with backend.   Any change - be it adding an Ax object, adding a record etc immediately gets synchronised with backend.  These synchronisation are covered and guaranteed under a horde of regulations. 

Based on above reasons, I don't think you can get DAX working the way you want.

Regards,

Harish Mohanbabu
Long way to go before I sleep ..

View Harish Mohanbabu's profile on LinkedIn

Page 1 of 1 (2 items) | Get this RSS feed | Bookmark and Share