Sample Header Ad - 728x90

Centralized master data shared among other several DBs

3 votes
1 answer
155 views
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!!
Asked by Hauri (585 rep)
Jul 2, 2014, 11:01 AM
Last activity: Aug 3, 2014, 10:10 AM