How Can I Run the SQL Scripts manually? - Bring2mind

Site
Web

Bring2mind Forums

Forums
Search Forum
Advanced SearchTopicsPosts

Prev Go to previous topic

Go to next topic

Forums Document Exchange Lite Installation and Activation Issues

Last Post 04/27/2007 10:15 AM by Peter Donker

How Can I Run the SQL Scripts manually?

2 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

jwthornhill

New Member
Posts:1

04/26/2007 4:18 PM
There are some "seperation of duty" issues in our environment (our DBA) ,that prevents us utilizing the module installation wizard to complete our install of Document Exchange 3 Professional. We have found 52 SQLDATAPROVIDER files in the compressed folder which contain what looks like the sql scripts but, were wondering if there is a specific order or method? Thanks

Peter Donker

Veteran Member
Posts:4536

04/27/2007 10:13 AM
JW, The order is in the file names and it is meant to be run by DNN. They are all carefully made to work with the DNN installer and make upgrading possible. All DNN modules that need DB objects to be created (should) use this method. There is a lot of material online about this on dotnetnuke.com. It sounds to me like the "seperation of duty" issue has made properly working with DNN next to impossible. Good luck with your task. Peter

Peter Donker

Veteran Member
Posts:4536

04/27/2007 10:15 AM
O, I forgot to answer the question in the title: yes, you can. Go to Host > SQL and copy-paste the contents of each file (in the order previously mentioned) in the box, select 'run as script', and hit run. Alternatively copy the contents to SQL manager and search and replace the 2 placholders {databaseOwner} and {objectQualifier} and make sure they correspond to your settings (by default 'dbo' and nothing).

You are not authorized to post a reply.

Forums Document Exchange Lite Installation and Activation Issues

About Bring2mind

Bring2mind is the company of Peter Donker, a DotNetNuke enthusiast who has been involved with the platform from the very beginning. At the same time as the market for modules emerged, he realized there was no good document management solution for the platform yet and he set about creating this. In part he based the module on his experience with other document management systems he used while working as a researcher. His module, Document Exchange, was an instant success and has since become the premier document management solution for DotNetNuke. In 2004 he created Bring2mind as a vehicle for the module and is one of the few successful businesses solely based on a DotNetNuke product.

Contact Info

Please note we are located in Europe. Business hours are weekdays between 9 AM and 6 PM local time (Central European Time) which corresponds to 3 AM and noon EST.