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 |
misterraj
Yak Posting Veteran
94 Posts |
Posted - 2011-06-19 : 16:34:07
|
hi,we are building a SaaS product, we are seeing if it allocate single datbase per client or a shared datbase where all clients can use.if we go with shared database, will horizontal partitioning help? I understand that horizontal partition is all about having the database split into 4 -5 different databases.In actual scenario how is a horizontal partitioning done? can any one throw a light on that please?thanks |
|
misterraj
Yak Posting Veteran
94 Posts |
Posted - 2011-06-19 : 16:40:45
|
I want the Horizontal paritioning of databases, so that client 1 - 10 can use one database.client 11-20 can use another database. etc.,will these database names be different? how will the application know which database to point to?? |
 |
|
|
|
|