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 |
|
programer
Posting Yak Master
221 Posts |
 Posted - 2011-01-23 : 07:43:26
|
| Hi,I have several web applications with the same function so I am interested in your proposal.What is better for you that for every web page, or use one database for each application separately?The problem arises when I have 10 applications and 10 different databases. If there is a fix in one database Icorrect at all.What would you do: one database for all 10 applications or 10 separate databases?Lp,Dejan |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-23 : 07:50:43
|
10 separate databases, but for commonly used or recurring functions that are not application specific, you could create a common database for such things. All your functions could be in one database that way, but your application specific data would be in application specific databases. (application specific functions/procs would be in the application specific database.) our shop does something similar to that so that there is only one location for objects potentially accessed from all the applications.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
programer
Posting Yak Master
221 Posts |
Posted - 2011-01-23 : 08:34:22
|
quote:
Originally posted by dataguru1971
10 separate databases, but for commonly used or recurring functions that are not application specific, you could create a common database for such things. All your functions could be in one database that way, but your application specific data would be in application specific databases. (application specific functions/procs would be in the application specific database.) our shop does something similar to that so that there is only one location for objects potentially accessed from all the applications.
Poor planning on your part does not constitute an emergency on my part.
Thanks for your reply.How do I save ID_aplikacation?example:tbl_aspnet_membershipcolumn ID_aplication primarykeyIf one store to the domain www.domain1.com, and one stores data on the domain www.domain2.com how to save the ID of the first domain, and how to ID the other domain?The data read from the config file on each domain?Eg.:www.domain1.comConfig file contains:ID = 1Eg.www.domanin2.comConfig file contains:ID = 2Do you have an idea? |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-23 : 08:55:56
|
Not sure I understand the question....now I am not sure I understood the first one...what does this have to do with the first question?
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
programer
Posting Yak Master
221 Posts |
Posted - 2011-01-23 : 09:01:04
|
quote:
Originally posted by dataguru1971
Not sure I understand the question....now I am not sure I understood the first one...what does this have to do with the first question?
Poor planning on your part does not constitute an emergency on my part.
If I have one base and 10 different applicationshow to save an additional attribute: ID of the first applications, ID other applications, etc... ?In the config.in file? |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2011-01-24 : 09:46:26
|
| Is this like you have 1 Web application with 10 different Customers on 10 Different Databases. All 10 Databases are same table structure? |
|
|
|
|
|
|
|
|
More bases or one?