Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm researching and investigating about all possible ways to create a master data database for my portfolio of applications. To give you a quick overview, an example will come in handy:

I want to create a Users database that several different applications will use. Instead of creating user tables in each application I need to centralize in one point all these users data and their permissions, for each application.

All this applications have MS SQL server as rdbms, so the Replication engine with a single publisher and several subscribers is an option. However, I would like to know if there are other alternatives, and what's more important, if any of these alternatives could be platform independent (for example, a master DB designed in MySQL with two slaves which could be Oracle and MS SQLServer).

Thanks for your help!!

share|improve this question

If your environment is currently heterogeneous or you're moving in that direction already, look into using an enterprise service bus to abstract away the implementations of each database. If it isn't, then I would advise against doing so unless absolutely necessary -- this will complicate your environment a lot, especially as you start adding in HA/DR solutions.

Replication should work for SQL Server. I'm not 100% sure of the exact supported features for heterogeneous replication, nor are your requirements very specific in the question, so I can't comment on that.

Master Data Services is a SQL Server only solution (introduced in 2008 R2, which is higher than the version you've tagged the question with), and beyond that I'm not familiar enough with it to say if it would work for your situation.

share|improve this answer
Hi @Jon Seigel, I'm sorry for the really late answer. This issue araised some time ago and then was delayed due to project requirements, but it is now again really a priority. Could you please give more information, examples or links about this enterprise service bus you were suggesting? Any other ideas would be also very appreciated. – Hauri Aug 31 '15 at 11:05

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.