Understanding the DNN Database

DNN Implementation partner explains the DNN SQL database

Work With Us

resources

dnn resources breadcrumb separator

understanding the dotnetnuke database

The Power of the Database

DNN on SQL Database

DNN (formerly called DotNetNuke) uses SQL as one of its core database technologies. The database stores all of the information for the site and this allows DNN to function as a true content management system. Rather than having to make changes to individual pages, changes are made to the database and the site is served up to the user based on what is stored in the database.

You can compare DNN CMS to other content management systems (WordPress, Drupal, Joomla) here.

Instead of having to work with a webpage where security is a constant headache, the DNN SQL database provides a very structured and flexible way to control access to the various pages and other content that make up the site.

Secure, Stored, Shared

Is a Database Necessary?

Without the database, there is no DNN. DNN takes all of the information that goes into the site from the database tables and therein lays the heart of what it has to offer. This allows features such as granular control over security and the ability to update the site on the fly, without having to upload new pages every time a change is made.

Database technology along comes with a ton of features. It makes all the database load balancing, synchronization, backup and redundancy options available for your site(s).

Without the database, there is no DNN. DNN takes all of the information that goes into the site from the database tables and therein lays the heart of what it has to offer.

Permissions & Installation

Understanding the DotNetNuke SQL Database

If your responsibilities end at getting the basic site up and running, you won't need to know that much about SQL to get a DNN site going. You'll have to install SQL on your server and create an empty database to house the site. One of the advantages of the DNN SQL system is that one can create many different sites very quickly in this way.

Quite frequently, people run into problems when permissions come into play. To properly install DNN, the database has to be installed at the root of the server. If the installation isn't done in this way, the administrator will not have the proper access they need to make all the changes to the site. Make certain that you have this level of control when you sign up for your web host.

DNN SQL databases are like any other SQL databases. Information is stored in an organizational system based on columns and rows and the ability to change that information and the structure of the database is strictly controlled by the administrator. When you change the data in one of the SQL containers, the data that appears on the webpage that DNN creates for the user will change, as well. This and the incredible search features of the SQL database are among the reasons this system is so popular with very dynamic sites that have constantly updated information. DNN is a great platform with which to build your web presence.