Question Status

Suggested Answer
Mohammed Khatib asked a question on 16 Jun 2013 1:08 AM

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.

Reply
Suggested Answer
Mohamed A.Raouf Elkhouly responded on 16 Jun 2013 4:22 AM

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.

Reply
Suggested Answer
Tommy Skaue responded on 16 Jun 2013 8:07 AM

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 | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no

Reply
Paul Musiej responded on 16 Jun 2013 11:19 AM

It is not possible

Reply
Suggested Answer
André Arnaud de Calavon responded on 16 Jun 2013 11:10 PM

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.

Reply
Malcolm Burtt responded on 17 Jun 2013 7:56 AM

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

Reply
Suggested Answer
Mohamed A.Raouf Elkhouly responded on 16 Jun 2013 4:22 AM

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.

Reply
Suggested Answer
Tommy Skaue responded on 16 Jun 2013 8:07 AM

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 | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no

Reply
Suggested Answer
André Arnaud de Calavon responded on 16 Jun 2013 11:10 PM

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.

Reply