c# easy way to create new db when new customer is added

Question

what can be a easy way to create new db when we create new customer record?

Scenario:

I have list of customers [may be upto 500 customers] in master database
Whenever I add new customer in my application, I would like to create new separate database to each client [just to separate respective clients' data entirely from each other]
Application will connect to master database and respective client db as per login credential.
- No of customers may be upto 500,
- I am planning to add only 50 dbs per server instance, after that again will be adding to next server instance

Options I have selected:

Use Code first approach of ef6.0 to create and seed primary data of each client when new client is added
Use Custom "Create database script" and import seed data from custom script.sql file

You may want to test how your SQL Server performs if it has 500 databases on it. And you may find stackoverflow.com/questions/21844479/… of use. — mjwills
– mjwills, Commented Jun 4, 2017 at 12:01
of course i will be seperating 50 dbs per instance of sql server. — KoolKabin
– KoolKabin, Commented Jun 4, 2017 at 12:03

CodeNotFound · Accepted Answer · 2017-06-04 12:01:57Z

1

Copy SQL Server database in code would be a reasonable option for backing up and restoring an existing 'vanilla' (i.e. with no customer data in it) database.

Of course you only need to backup once - you just restore for each new customer.

edited Jun 4, 2017 at 12:01

CodeNotFound

23.4k10 gold badges75 silver badges73 bronze badges

answered Jun 4, 2017 at 11:55

mjwills

24.1k6 gold badges45 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

KoolKabin Over a year ago

seems good and easy option... trying it right now... btw i miss creating blank db to new customer before restoring it with backup of existing db

mjwills Over a year ago

Excellent - I am glad I could be of assistance!

Collectives™ on Stack Overflow

c# easy way to create new db when new customer is added

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related