Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Custom SQL scripts during Install?Custom SQL scripts during Install?
Previous
 
Next
New Post
6/5/2007 1:02 PM
 
David Gerding

Joined: 12/11/2003
Posts: 87

Hi,

I was wondering where I should be putting my custom SQL scripts to be installed by DNN at installation time?  I am talking about "application wide" scripts that aren't specific to a module.  I tried putting scripts in the \website\install\scripts folder, but that didn't work.  Is it a naming convention thing?  What am I missing?

Thanks,

Dave Gerding
 
New Post
6/5/2007 2:34 PM
 
Brian Dukes


Brian Dukes's Avatar

Brian Dukes's Avatar

www.engagesoftware.com
Joined: 8/25/2006
Posts: 896

Why are you trying to run SQL scripts at installation time?  I don't think there is any way to do this, the only scripts you should be adding would be for specific modules.  If you have other application-wide scripts, you could install them after installation if needed.  Can you explain what you are trying to accomplish here?

Brian Dukes
Engage Software
St. Louis, MO
866-907-4002
DNN partner specializing in custom, enterprise DNN development.
 
New Post
6/5/2007 4:57 PM
 
David Gerding

Joined: 12/11/2003
Posts: 87

Thanks for the reply.  I have a number of custom tables that are used both by a proprietary version of the control panel (iconbar) and that are also leveraged by some other custom modules.  So, I was hoping to simply have a package of SQL scripts installed at installation time, before the module build out.

What if I just append the scripts to the last sql script in installl sequence?  Where are those by the way...

FMI, what is the Scripts folder under install for anyway?

Dave Gerding
 
New Post
6/5/2007 5:13 PM
 
Brian Dukes


Brian Dukes's Avatar

Brian Dukes's Avatar

www.engagesoftware.com
Joined: 8/25/2006
Posts: 896

The install scripts are in \Providers\DataProviders\SqlDataProvider.  After some more digging, it appears that whatever is in the Install\Scripts folder upon install should run so long as it has the extension .SqlDataProvider (or whatever your default data provider is).  Was that the extension of the scripts that you tried before?

From what I can find in the code, it appears to only run those on install, or when the mode querystring parameter on install.aspx is "executescripts," but to not run them on upgrade.

Let me know if that helps.

Brian Dukes
Engage Software
St. Louis, MO
866-907-4002
DNN partner specializing in custom, enterprise DNN development.
 
New Post
6/6/2007 10:11 AM
 
David Gerding

Joined: 12/11/2003
Posts: 87

Brian,

This is a big help. I had the wrong extension (just .sql).  I'll go give this a try.  Much appreciated.

Dave Gerding
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Custom SQL scripts during Install?Custom SQL scripts during Install?


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