AX 2012 - Save each Company data on a separate database

This question has suggested answer(s)

Hello all,

I am facing a problem at one of my clients,

They are requiring that each company has a database instance that save the data on, rather than having a one holding database for all companies?

How can that be approached, is it doable or not?

Thanks All.

All Replies
  • You can consider portioning in AX, it is very similar and will be totally separated for the data as if you are using two separate databases.

  • You can't install AX business data over multiple logical databases. There are artifacts that are still shared across partitions, for example the Service and Integration Ports (formerly known as AIF).

    Tommy Skaue | Dynamics AX Developer from Norway | |

  • It is not possible

  • Even the partitions in AX will store the data within the same database. It has nothing to do with the SQL partitioning. The requirement is not possible. The only way is to buy an AX license per company. You then have to install and setup per company. This is not recommended.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

  • Hi

    I think you should start by asking the customer why they want to do that. I can't believe that they specifically want each company in a different database - that's a technical "solution" to a specific requirement. Its not logical to ask for that unless there is a specific business requirement driving it.

    So what is their actual functional requirement? Once we know that we can probably come up with a way in AX to deliver it.

    Malcolm Burtt