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 |
|
ashams
Starting Member
1 Post |
 Posted - 2008-01-23 : 08:00:39
|
| I need help on design decision. we are developing an intranet application using asp.net and sql server 2000 for a group of Institutions.With the present design is there is a common database fro all institutes which has user related info and master tables and antoher databasefor all institute related data.This second database we are planning to replicate for each institute. That is the schema is same, but the data will be different.Is this design a practical one/ is there a better strategy?The issues in front of us are1. we are having all the master tables in the common database.Should we replicate this to each individual database ,if so how?2. Otherwise how should be the databse design.In future one of the institute may move to a differnt location, if we are having individual databases this migration will be easier we feel.3. can anyone give me nay sample or any useful link.thanks & regardsThere is some self-interest behind every friendship. There is no Friendship without self-interests. This is a bitter truth." |
|
|
gvphubli
Yak Posting Veteran
54 Posts |
Posted - 2008-01-30 : 23:14:31
|
| I think you can restore the backup copy of current database as DB01, DB02...for different institutions. And from each database restored so you can delete the unwanted data.It is always good to have seperate databases.There are no tools that I can think of specific to your case.TechnologyYogihttp://gvphubli.blogspot.com/ |
 |
|
|
|
|
|
database design