Learn More





DNN Community Blog

The Community Blog is a personal opinion of community members and by no means the official standpoint of DNN Corp or DNN Platform. This is a place to express personal thoughts about DNNPlatform, the community and its ecosystem. Do you have useful information that you would like to share with the DNN Community in a featured article or blog? If so, please contact .

The use of the Community Blog is covered by our Community Blog Guidelines - please read before commenting or posting.

Installing Our Module in Another DNN Instance

Throughout this series anytime we created a table or stored procedure in our database I always mentioned that we needed to update our SQLDataProvider files. To do that we went back and updated our SQL scripts to include the {objectqualifier} and {databaseowner} properties. I mentioned that DNN would replace these properties during install and that was related to the portable nature of modules (you can install them into any DNN site and they work). All of that may have been initially hard to visualize. You might have thought… why would I want to install this module somewhere else or why do I need to keep updating these files? I also had those some thoughts while I was learning.

Well, early on in development you may not see a need to install your module somewhere else, but in time you may. If you want to share your module with someone else, if you want to sell it on the DNNStore, if you want to post it on the DNN Forge, or install it in some testing environment then having an easily installable module will be helpful. In these scenarios being able to properly install the module in a different environment will become critical as all these environments may potentially have different SQL Server and database names. This is why it’s important to keep the SQLDataProvider scripts updated and included with your module.

{objectqualifier} and {databaseowner} Are Not Requirements
Though, I will note that if you don’t intend to distribute your module or install in other locations, such as environments you don’t control, it’s perfectly fine to not update these files and not use the {objectqualifier} and {databaseowner} properties in your scripts. If you are a developer who is developing in your own controlled environment without the desire to sell, share, or donate your code then you can still manage your database objects the way you know how and use standard SQL scripts within your module. The {objectqualifier} and {databaseowner} properties are not requirements to develop a module rather they are features that provide more flexibility & portability for your module. Though, like I just mentioned, if you are not concerned with that then feel free to omit this step in the process. And you think to yourself… well why did you make me update these scripts in this tutorial then? I’ve shown you how to update these in the case that you want to install in other locations or distribute your module in the future. Having knowledge of this capability is beneficial in general and it helps us understand how DNN is architected.

So let’s test it out… find another DNN instance (or optionally re-install DNN on your local machine by following this blog again) and try to install the module.  If all goes accordingly then the module will install, the tables & stored procedures will be created and you’ll be up and running with the same functionality in a totally different environment within minutes. This is one example of the power of DNN’s modular architecture. Having a loosely coupled system provides this level of flexibility.

This video walks through installing our Tasks module into a different DNN instance

As we’ve discussed DNN is architected in a module fashion. This modular nature of DNN provides a lot of possibilities and flexibility to DNN developers and admins. Keeping track of our SQLDataProvider files ensures that we as module developers can leverage this portable power within our modules. In the next entry we will wrap this series up with some final thoughts and details. I hope to see you there!

Go to the Final Blog Entry: "Module Development for Non-Developers, Skinners, & DNN Beginners Series Conclusion"


James Brown
Link to the series introduction

Link to the previous Blog Entry:
James Brown Monday, June 15, 2015 11:49 AM (link)

Comment Form

Only registered users may post comments.


2sic Daniel Mettler (125)
Aderson Oliveira (15)
Alec Whittington (11)
Alex Shirley (10)
Andrew Nurse (30)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (22)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (203)
Chris Paterra (55)
Clinton Patterson (28)
Cuong Dang (21)
Daniel Bartholomew (2)
Dave Buckner (2)
David Poindexter (3)
David Rodriguez (2)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (74)
Geoff Barlow (6)
Gifford Watkins (3)
Gilles Le Pigocher (3)
Ian Robinson (7)
Israel Martinez (17)
Jan Blomquist (2)
Jan Jonas (3)
Jaspreet Bhatia (1)
Jenni Merrifield (6)
Joe Brinkman (270)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (4)
Jordan Coopersmith (1)
Joseph Craig (2)
Kan Ma (1)
Keivan Beigi (3)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Malik Khan (1)
Matthias Schlomann (15)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (3)
Michael Washington (202)
Mike Horton (19)
Mitchel Sellers (28)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Peter Donker (52)
Philip Beadle (135)
Philipp Becker (4)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott S (11)
Scott Wilkinson (3)
Scott Willhite (97)
Sebastian Leupold (80)
Shaun Walker (237)
Shawn Mehaffie (17)
Stefan Cullmann (12)
Stefan Kamphuis (12)
Steve Fabian (31)
Timo Breumelhof (24)
Tony Henrich (3)
Torsten Weggen (2)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (37)
Will Strohl (163)
William Severance (5)
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?