locked
When lawyers interfere in a SQL Deployment Strategy... RRS feed

  • Question

  • Hi to everybody,

    I suppose I have a tough question, as my MS partner has not been able to provide me an answer yet.

    I have several companies in different countries in which I must implement Dynamics AX. The issue is that I would like to have all the data in a single SQL database so all the users can collaborate and the info could be shared, etc. Unfortunately the legal folks won´t allow me to store all the data in the same geographical place. They want the data of each company physically located in each location.

    Is there a way to have a single database but splitting the infomation accross several servers? Any other recommendations?

    Thanks in advance,

    Thursday, July 28, 2011 2:28 PM

Answers

  • Hi,

    You can not have a single DB across multiple servers, but you could create DBs with same schema on each server and then join the data together for reporting useing either linked servers (or if this is not allowed) then you could create SSIS Packages that join the data together and then send as report, etc.


    Peter Carter http://sqlserverdownanddirty.blogspot.com/
    Thursday, July 28, 2011 2:40 PM
  • You have to create different databases for each geographical place.

    may be couple of table which are elizable to share data across geographic can shared with replications.

    Where as tables which holds legal info should be separated geographic wise and not share them with other locations....

     


    http://uk.linkedin.com/in/ramjaddu
    Thursday, July 28, 2011 4:21 PM

All replies

  • Hi,

    You can not have a single DB across multiple servers, but you could create DBs with same schema on each server and then join the data together for reporting useing either linked servers (or if this is not allowed) then you could create SSIS Packages that join the data together and then send as report, etc.


    Peter Carter http://sqlserverdownanddirty.blogspot.com/
    Thursday, July 28, 2011 2:40 PM
  • You have to create different databases for each geographical place.

    may be couple of table which are elizable to share data across geographic can shared with replications.

    Where as tables which holds legal info should be separated geographic wise and not share them with other locations....

     


    http://uk.linkedin.com/in/ramjaddu
    Thursday, July 28, 2011 4:21 PM