Hi

I guess you've probably already worked out the answer to this one. I was looking for the same answer and found it on Michael Washingtons Survey module tutorial:

http://www.adefwebserver.com/dotnetnukehelp/DNN4_SurveyModule/

I was kind of hoping DNN would somehow build the SQL scripts automatically too!  alas..

Yes, you have to write the scripts yourself and paste them into text files.

Some good examples can be found on Michael Washingtons Survey module tutorial: The files are listed in this blog post.

http://www.dotnetnuke.com/Community/Blogs/tabid/825/EntryId/1164/New-Survey-Module-Tutorial-C-and-VB.aspx

It's important to note that the scripts must be incrememental. i.e. Each version you create of the module must create a new script (if it changes the db objects) that uses ALTER to change the objects. This can become a real headache when data is going into the tables and there are key constraints to deal with. Careful testing has to be carried out before upgrades are released.

You should also create an uninstall data provider file which deletes all the objects that the module creates. 

These data provider files are just text files but I think DNN converts them into some other format that it executes when the module is installed/uninstalled.

Gus

---

"if the only tool you have is a hammer you tend to see every problem as a nail" http://www.carawaydesign.com

I just want to add that http://www.ssmstoolspack.com/ provide additional useful features for generating sql scripts.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN