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

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ...Migrating DNN 4.6.0 From SQL 2000 to SQL 2008Migrating DNN 4.6.0 From SQL 2000 to SQL 2008
Previous
 
Next
New Post
5/31/2012 2:20 PM
 
Neg Bero


Joined: 7/22/2005
Posts: 4

Hi all,

I have a few questions regarding migrating dnn from one server to another. The company I work for currently is using DNN4.6.0 and would like to move the site to another server. Currently the DB (over 100gb) is running on server 2003 and has SQL 2000 and the same configuration for the IIS on a different server. Now we are getting 2 new servers one for db and one for iis. My question is could I just do a backup of the db that is is sql 2000 and restore it on sql 2008 without any conflict and same thing with the iis could move the file to a more recent iis on a new server. What is the best way of doing that without having to upgrade to dnn 6.X.  I have 120 portals and over 300 users (admins). Please help.
 
New Post
6/1/2012 2:28 PM
 
cathal connolly


cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676

hello,

yes, thats entirely possible. You either need to detach and attach the database or else do a backup and restore to do so (create a database first and select "force restore" when restoring over it). Typically you need to fix the "orphaned" users as whilst the data is moved across the users aren't - see http://www.fileformat.info/tip/micros... (or else drop and create a new user -ensuring they're set as dbo). You'll probably want to add a portal alias for your new server first in DotNetNuke to allow you to test.

As for the folders and files they just get moved over, though you'll have to update the 2 connectionstrings in web.config to point to the new database server details

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
6/4/2012 9:02 AM
 
Neg Bero


Joined: 7/22/2005
Posts: 4
Hi Cathal,

Thank you very much for the quick response. I will get that started next week when I get the go ahead from my manager. I will let you know how everything went.
 
New Post
8/10/2012 2:43 PM
 
Neg Bero


Joined: 7/22/2005
Posts: 4
Just heard back from my manger and I'm moving with the migration next month. Now when configuring the IIS server, the asp.net needs to be install prior to to the IIS?
 
New Post
8/10/2012 7:05 PM
 
cathal connolly


cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676
yes, you need to install the .net framework on the IIS server (depending on the version of windows it may already have .net 2.0, but you need need to ensure .net 3.5sp1 is installed - and its also a good idea to install .net 4.0)
Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Migrating DNN 4.6.0 From SQL 2000 to SQL 2008Migrating DNN 4.6.0 From SQL 2000 to SQL 2008


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