If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Microsoft SQL Server > Advice needed. Need a database middleware?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jul 2010
Posts: 6
Advice needed. Need a database middleware?

Hi, would like you guys' advice. Let's say we have system A, system B and system C and each system has its own user management module/tables. Meaning system A's user management module is at database A, system B's user management is at database B and system C's user management is at database C.

Now, we plan to centralized user management module by creating a separate database, say database D and to have system A, B and C to use user management in database D. Once successfully, those user management tables in database A, B and C will be removed.

In this design, do we need some kind of database middleware for system A, B and C to connect to database D. Secondly is what if system B need to add a special field in a user management tables in database D?
Reply With Quote
  #2 (permalink)  
Old
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 12,561
You could replicate the data to the disparate databases.
This would probably be best, as in the event of the network breaking down each database would still maintain a copy of the latest available user settings, and could continue functioning.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
www.LobsterShot.blogspot.com
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jul 2010
Posts: 6
hi thanks for the reply. actually reliability is not so much of our concern now. What we concern more is the design. Just like what I mentioned earlier, if system B needed extra field from the database, how do we go about it if we got once centralized database for all 3 systems?
Reply With Quote
  #4 (permalink)  
Old
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 12,561
Quote:
Originally Posted by ngaisteve View Post
actually reliability is not so much of our concern now.
First WTF of 2013.
Regardless, Replication is still probably the best solution for you. You can set up separate replication packages for each client database, if necessary, and replication can be configured at the column level.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
www.LobsterShot.blogspot.com
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Jan 2013
Location: Woodland Hills, CA
Posts: 18
I agree with blindman. Irrespective of whether you're in the design phase or the development phase (looks like you guys are still in design phase), reliability should always be at the forefront of your solution. If it's not reliable then can you really trust the data that you're seeing?
Reply With Quote
  #6 (permalink)  
Old
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 12,561
Quote:
Originally Posted by YesAgile View Post
I agree with blindman.
You're going to fit in well here.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
www.LobsterShot.blogspot.com
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Jan 2013
Location: Woodland Hills, CA
Posts: 18
hahaha!
Reply With Quote
  #8 (permalink)  
Old
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 12,561
Join us in the corral: OK Corral
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
www.LobsterShot.blogspot.com
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On