Products

Solutions

Resources

Partners

Community

Blog

About

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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...How do I use 1 database for multiple DNN instal?How do I use 1 database for multiple DNN instal?
Previous
 
Next
New Post
5/6/2006 11:36 AM
 
You're hitting upon something that you might indeed have to deal with.  But unless you do want to deal with it then your only other option is completely separate installations of dotnetnuke in different hosting accounts (ie. instead of $10 a month you'd be paying $30 for 3 separate accounts).

There are tools to help you migrate one portal (www.snowcovered.com) though I haven't used any personally so I can't comment on ease of use/effectivenesss.

When I've had a site like this I've just backed up, restored the backup at the new host (or to my development machine and then sent a detached db to the new host), then deleted extraneous portals.  I don't know if there are better ways to do it.

/Brian C
 
New Post
5/6/2006 12:42 PM
 
Hello:

Everything that BriC has said I agree with 100%.  I had concerns about what you are talking about, and have been able to effectively split out some fairly involved DNN sites, i.e. many modules and users, without needing to do anything too complicated.  I did rely on one module I purchased from snowcovered.com for transferring the user accounts and passwords, which worked perfectly and is very reasonably priced.  Below are some points that might give you some ideas as well as help those who are looking to upgrade their single or mult-portal sites from DNN 3.x to DNN 4.x:

If you plan to upgrade from 3.x to 4.x I would recommend starting as fresh as possible.  Below is a quick summary of the steps:

  1. Logon to your DNN 3.x site as "Host" and go to "Host" > "Portals".  There is a rather nifty tool here that will allow you to export your site settings and data (make sure the data checkbox is checked). This will create two files, NameYouGave.template and NameYouGave.template.resources.
  2. Begin to setup your new DNN 4.x website, but prior to running or creating your site copy the two files from step (1) located in your DNN 3.x portals\_default folder to the DNN 4.x portals\_default folder.
  3. Rename the existing files, DotNetNuke.template and DotNetNuke.template.resources, to DotNetNuke.bak.template and DotNetNuke.bak.template.resources and rename the files you created and copied to the DNN 4.x Portals\_default to DotNetNuke.template and DotNetNuke.template.resources. *(refer to the alternative way below to achieve the same result).
  4. Run the solution or create your Portal as you normally would and you will have a new DNN 4.x website with your DNN 3.x stuff (Note: If you have custom modules, skins, etc. you will need to install these again.)

This will NOT port your user's information over.  I would recommend using a tool like BulkUser Import&Export that you can get at a reasonable price from snowcovered.com. 

*There is an alternative way to do Step (3) as well.  Instead of renaming the DotNetNuke template and resources files, create your site as normal using the DotNetNuke template provided, and add your skins and modules.  Then add a Parent Portal and select your resources files you created and copy them to Portals\_default, making them available from the template dropdown.  When you create your portal select your template and your parent portal website will be created with the same skin, data, etc.  You may need to go through some of your pages, i.e. pages with HTML Modules and change the portal from say "3" to "1".  This all depends on the portal number assigned in DNN 3.  This will ensure your URLs etc. point to the proper location of images and other resources.

If you would like to do this for a multi-portal site and are working locally, i.e. using a backup of your database and website from your web hosting company, you can do this as well by performing one additonal step.  You will need to access your database and open the PortalAlias table and set the portal alias name to the virtual website you setup locally, i.e. localhost/dotnetnuke then export your site with data, then change your next portal alias record in your database this URL (blank or change the previous so thiis alias is effective for only one site at a time) to  ocalhost/dotnetnuke, etc.  The assumption here is that you are making changes locally prior to FTP'ing your site to your hosting company.  The method here that I used let me use the same virtual website, rather than creating one for each parent portal.  You can create as many virtual websites on your local machine as you have portals, and is simply a preference.  In either case, make sure the portal you would like to export is mapped properly to your local website of choice by changing the PortalAlias record in your database for each portal. 

I hope this helps and provides you with ideas on how to upgrade from DNN 3.x to 4.x and/or gives you ideas on how to split out a single portal website from a multi-portal site that uses the same database.

John
 
New Post
5/6/2006 6:42 PM
 
Thanks for the help guys.  I'll try out the steps you guys suggested.

I think it might be a good feature for future release of DNN to allow using a prefix while creating the database tables.  Wordpress has this feature and I thought it was very useful.


 
New Post
5/6/2006 6:45 PM
 

it does, you just need to set a value for the objectQualifier in the web.config file.

Cathal


Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
5/6/2006 7:33 PM
 

This is a good feature to use and I almost ruined an install by not using an object qualifier for my database objects.  In DNN 4.0.3 (not sure if this is in prior releases) in the source install there are two config files, one called development.config and the other called release.config.  Curious as to what the differences are between them, I found that one is that the development.config file has and object qualifer of "dnn_" while the release is an empty string. I think its a good idea and one you'll want to use if you are a module developer.

John

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...How do I use 1 database for multiple DNN instal?How do I use 1 database for multiple DNN instal?


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