Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-14 : 10:49:38
|
| Vikas writes "Relating two databasesHi,I am creating an application that I have logically divided into four parts. For example: Bank, Addressbook etc.I need some suggestion with database architecture. I have two choices here:1. Create on database for the whole application and create all the required tables in this database.2. Create four databases, where each database represents the logical part of my application. For exampledbBank represents bank module and so on.However, I want to centralize my reusable data in one database and then access it using other databases. For example:there is a table named tblPersonMaster, that contains the data related to individuals. Now this datais used in Bank as well as Addressbook module. I want to create a database named dbPerson and have this table in that database. Then I would like to integrate other databases requiring 'Person' data with this table.To summarize:1. I have created a database named dbPerson that has a table tblPersonMaster.2. I have created another database named dbBank that requires some data from tblPersonMaster in dbPerson.Is this possible to have a relationship between two databases?If yes then are there any performance issues ??Thanks In Advance." |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
|
|
|
|
|
Relating two databases 