Hello,
I have gone through a couple of tutorials for creating DNN modules that access database tables & stored procedures within the DNN database. However, at some point in each of these tutorials, I had to run a script to create the tables & stored procedures used by the module (by using the "SQL" command under the "Host" menu").
This works, but this doesn't make the module "portable". That is, when I create an install package for my module, it doesn't include the creation of these database objects. When I run my install on a new portal, the module is created correctly (aspx files, VB files, etc), but the database objects are not created. Of course, I could run this same script again to recreate these on the new portal, but there must be a better way (?). Obviously, I am missing something in the development of the modules, as I know other modules I have installed (from other people) create their database elements as the install is run.
I would appreciate anyone pointing me in the right direction (links, example, keywords I should be looking for, etc). Thank you!