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 |
|
cra
Starting Member
2 Posts |
 Posted - 2005-09-30 : 07:11:51
|
| I work with more application with databases.i have database1 for application1, database2 for application2 and database3 for application3in all these database a have a general table (t_client)when i make a client in my application1, a want to see this on my appliction2 with database2.So i make a new database (general) and make my table (t_client) on it.i want to delete the table (t_client) from database1,2 and 3. And link (t_client) from my general database to all my other database.Is this possible??? |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-10-04 : 16:14:45
|
| Yes your approach also will work fine. You want to keep all common db objects into one database and going to refer that DB tables whenever you require. fine.---------------------------------------------------------------------------------------I have one more approach, without making any major changes ....Keep all the individual database1, 2,3 and tables 1,2,3 like that.On top of why cant U create a Partition view likecreate view Vw_part_data asselect * from database1.db.table1Union allselect * from database2.db.table1Union allselect * from database3.db.table1With RegardsBSR |
 |
|
|
|
|
|
client stucture in one database