locked
One Database or Multiple Databases RRS feed

  • Question

  • I need to create an application where we will manage our employees, client's and Job orders. We have 20 Branches and growing  across the nation. Each branch will have their own employees, client's and Job orders. This application will handle over 30000 employees. Should I use one Sql database for all branches or would I be better of creating one database per branch.

    Thank you.


    Rogelio Rios

    Friday, February 5, 2016 5:22 AM

Answers

  • Hi Rogelio,

    It is a good practice to have data for individual branch in one database. This will provide you the benefits of better data isolation and security.

    You can assign individual databases to each branch and use elastic database tools to manage the membership, and route the connection to appropriate databases. You can read more about it here

    In addition to that, you can use Elastic Pools to combine databases on cost and capacity sharing basis. Here is more information about elastic pools.

    Hope this helps!


    Thanks Silvia Doomra

    Friday, February 5, 2016 7:22 AM