5 Replies - 760 Views - Last Post: 30 September 2014 - 03:06 PM Rate Topic: -----

#1 aczwicker   User is offline

  • D.I.C Head

Reputation: 2
  • View blog
  • Posts: 50
  • Joined: 23-May 12

Creating New Database per client - Store database name in another db?

Posted 30 September 2014 - 02:24 PM

I have recently created a database driven software solution that I want to put on the market. I have a perfectly stable database that works great, but I do not want to use a multi-tenant structure.

When a user logs on to my website and creates a new account, my software created a new database using their company as the database name. In order for the software to know what to set the SqlConnectionString to, should I have a seperate database and table that stores the username, companyName, password, and email so it can change the connection string to log in to the right database? Is this a best practice?

Any help is greatly appreciated!

Is This A Good Question/Topic? 0
  • +

Replies To: Creating New Database per client - Store database name in another db?

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 14552
  • View blog
  • Posts: 58,359
  • Joined: 12-June 08

Re: Creating New Database per client - Store database name in another db?

Posted 30 September 2014 - 02:27 PM

Quote

but I do not want to use a multi-tenant structure.

Why not?
Was This Post Helpful? 1
  • +
  • -

#3 aczwicker   User is offline

  • D.I.C Head

Reputation: 2
  • View blog
  • Posts: 50
  • Joined: 23-May 12

Re: Creating New Database per client - Store database name in another db?

Posted 30 September 2014 - 02:41 PM

View Postmodi123_1, on 30 September 2014 - 02:27 PM, said:

Quote

but I do not want to use a multi-tenant structure.

Why not?


From what I have researched, it seems that security is a big issue with these kinds of systems. Am I wrong?
I know that it depends on the programming, but I hear that certain tenants won't use a software simply because of the security risks of storing business data within the same database.
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 14552
  • View blog
  • Posts: 58,359
  • Joined: 12-June 08

Re: Creating New Database per client - Store database name in another db?

Posted 30 September 2014 - 02:47 PM

Eh.. it is really on the client. As long as your code has the right keys, sure.

As for your issue - it seems more of an order of operations issue. If your clients are concerned about their data in the same pot then the suggestion of having some reference table with important information in it won't fly. What you would do is get an order in for some company. You would kick off some process to create the table, etc. From there you would manually update any specific config files and ship that out.
Was This Post Helpful? 1
  • +
  • -

#5 aczwicker   User is offline

  • D.I.C Head

Reputation: 2
  • View blog
  • Posts: 50
  • Joined: 23-May 12

Re: Creating New Database per client - Store database name in another db?

Posted 30 September 2014 - 03:03 PM

View Postmodi123_1, on 30 September 2014 - 02:47 PM, said:

Eh.. it is really on the client. As long as your code has the right keys, sure.

As for your issue - it seems more of an order of operations issue. If your clients are concerned about their data in the same pot then the suggestion of having some reference table with important information in it won't fly. What you would do is get an order in for some company. You would kick off some process to create the table, etc. From there you would manually update any specific config files and ship that out.


That makes sense. What if the product was "cloud" based? Would it apply there?
Was This Post Helpful? 0
  • +
  • -

#6 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 14552
  • View blog
  • Posts: 58,359
  • Joined: 12-June 08

Re: Creating New Database per client - Store database name in another db?

Posted 30 September 2014 - 03:06 PM

Again - that depends on your client. Some folk are not happy with cloud security, trust people to do it right, or like having all their data munged together.
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1