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
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0SqlDataProvider How To?SqlDataProvider How To?
Previous
 
Next
New Post
1/9/2007 11:33 PM
 
Ian Lackey

Joined: 7/22/2006
Posts: 127

Is there any good articles out there about creating the TSQL scripts for modules? Any specifically about upgrading modules would be good. It is easy enought to figure out how to alter the 01.00.00 version, but how do you go about creating the scripts for say 01.00.01? I do not claim to be a TSQL master by any means but I do not see any easy way to generate this scripts easily without dropping your table(s) and loosing your data. I am sure it is something simple I am missing, but have not seen any good resources on the subject. Any help is greatly appreciated.

 

TIA

ITLackey
 
New Post
1/10/2007 8:31 AM
 
Néstor Sánchez


www.nestorsanchez.net
Joined: 11/15/2003
Posts: 1986
The scripts are needed only when you need to change something at the database layer, this can be objects (like tables, views or sprocs) or data itself. So nothing special is needed for upgrading modules. If you don't need to change anything in your db, then you don't even need to include a script.
Do you know the truth when you hear it?
Néstor Sánchez
The Dúnadan Raptor -->Follow Me on Twitter Now!
 
New Post
1/10/2007 11:36 AM
 
Brian Price

Joined: 10/5/2003
Posts: 85
You can create/drop stored procedures without losing data. You can modify existing tables for example, add/remove columns. You can create new tables and populate them with data from existing tables then drop existing tables. There’s quite a bit you can do. I really like the way DotNetNuke implemented database installs/upgrades. For example, If a customer has version 1.0 of your project they can upgrade to version 8 and get everything in between.

To learn how the upgrade works you can look at the DNN modules. The events module does quite a bit in its upgrade script.

Brian
Qualtiy DotNetNuke modules and custom development; we've been serving the DNN community for over 2 years and have hundreds of satisfied customers. Let us serve you today.
 
New Post
1/10/2007 1:09 PM
 
Ian Lackey

Joined: 7/22/2006
Posts: 127

Thank you both for the info, it confirmed a lot of my thinking. However, I think I was somewhat unclear as to the answer I am looking for. I have a pretty good handle on the upgrade process itself ,and maybe this is the wrong place to ask this question, but I am wondering if there is a tool that can do a comparison between two tables and generate the script needed to alter the table to include the changes. I realize this can all be done by hand and should not be a big deal as long as the changes are minimal after the first release. But the lazy developer is always looking for the golden key of automation.

It would be great to have a tool that allows you to select the SQL objects from two databases. Click a button and have a script returned to you that will modify database A to match database B's schema.

I apologize if this is not the appropriate place to ask this question. I just figured some one else might have found a way to automate generating module database upgrade scripts.

Thanks again for all of your help!
 
New Post
1/11/2007 12:53 AM
 
eck two

Joined: 11/15/2003
Posts: 364
You can use Enterprise Manager to generate your upgrade script.

If you use EM to modify the table design, right before you save the changes, click on the "Save change script" icon.  That will automatically generate the database upgrade script for that table.  If you want to conform to use Object Qualifiers, then you need to make additional adjustment to the generated script.

Other types of objects like stored procedure, it would be easier to delete the existing one and replace with the new one.  EM can generate those scripts as well.
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0SqlDataProvider How To?SqlDataProvider How To?


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