Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...Database Setup SuggestionsDatabase Setup Suggestions
Previous
 
Next
New Post
5/17/2011 10:00 PM
 
I'm setting up a SaaS product using DotNetNuke.
DNN doesn't need any intro here, so I thought this might be the best place to put it.

Since each company's data should not be visible by another, this brings up my question:
Which would be better, a separate database or everything in one single database, and why?
Also, consider that these will have to be updated about every month and as security patches come out.

I understand that having multiple databases would require me to have a database "key" or login to the other databases...recommendations on how to handle this...And would all the connection strings need to be added to the web.config file?
Whereas if I were to have a single database, I would have to have a Company ID on every field, this would impact all of my queries because of the required where clause.

Any Suggestions?
 
New Post
5/18/2011 11:11 AM
 
If you are using a single DNN installation with multiple portals, they will automatically share a single installation (make sure, only you, the host, gets direct access to the database). If you provide individual installs per client, you'll need individual databases (multiple DNN instances sharing a database using object qualifier is no longer supported since they can't properly share membership tables out of the box).

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
6/14/2011 7:29 PM
 
Sebastian,

Sorry for the late reply, I didn't receive an email telling me my post had been replied to.

I was talking about using a separate database for the modules that I was creating which would be linked to a portal.  The membership aspect of DNN would stay in place, and I would use the membership module to track entries and authorise which database(s) they can access based on portal ID, is that possible to do?  I've seen the option to use a separate database for modules, but what I was wondering is if a specific portal could be pointed to another database for the custom modules only.

For Example:
Both Company 1 and Company 2 use the DNN database for users, portal, informational pages, etc.
But Company 1 uses database A for the custom module stuff, and Company 2 uses database B for custom module stuff.

I Hope this is clear.
 
New Post
6/30/2011 8:18 AM
 
So (let's say) you have:
* 1 DNN (host) install
* 2 portals: 1 for each company (1 and 2)

Normally when you install a module, SQL scripts are run that create the database. This would be one database for all modules within that DNN installation (if I'm not mistaken). In your module you make sure that users (and thus companies / users of different portals) can't see each others data. So the basic approach doesn't let you create a different database for each company.

What you could try to do, is during your install, let the SQL scripts create a database in which you register the different databases used by each portal. You would have to have a setting in your module telling the module the name of the database to save the data in and some code that creates that database. I've no experience in such a setup, so I don't know if you will be able to pull this of and what you will run into. Please let me know if you are able to. Maybe Sebastian knows if this is a viable route?
 
New Post
6/30/2011 11:11 AM
 
Gerard,
in your own module you may access different databases, specified per portal (in siteSettings table) or per module instance (in moduleSettings table) without limitation.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...Database Setup SuggestionsDatabase Setup Suggestions


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out