Recently , I started to be involve in a Dynamic AX project.
For the moment, I discovered the following:
– Dynamic AX is not using the full power of sql server;
– sql server it is used only for storing; for storing , you can use a
spreed sheet from excel…
– is not a OLTP , more like a OLAP
– normalization ? what is this ?
– Reference integrity ? Trusted relations ? what are these ?
Before this, it was an internally developed ERP , that was doing the job. The final user was a little grumble, because they always throw stuff on developer , because they were inside company. After the new implementation, nothing was working, even now, after 3 years, are problems, speed is only slow and super slow. Now they say : “what good was previous ERP…”
I don’t know on what , management made the deci$$$ion to implement that solution, but definitely they took a wrong decision and they don’t have the power to admit …
S
Sql Server 