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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 in cloud

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??
Go to Top of Page
   

- Advertisement -