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 |
|
rdhoble
Starting Member
1 Post |
 Posted - 2010-08-30 : 02:13:31
|
| Hi,Currently having a single source code to support multiple customer base, but we have seperate schemas for all the customers. The problem is if there is a change in one schema we have to replicate that change in other 30 schemas. Is there any way we can keep only one schema for all the customers. Or any alternative to propogate the changes automatically to all the other schemas.Thanks,Rajesh |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-30 : 03:19:24
|
| Can you please explain the problem a little more detailed, preferably with some examples? "Schema" is a term with several meanings and can be interpreted differently... If "schema" is the definition of a table or stored procedure then the best option would be to have one single schema for all customers. If this is not possible you will probably need to have several customized versions of your source code as well...- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
|
|
|
Sigle Schema for Different Customers