You need to Register for free and Login to post a message in the forum.

Forum

Forums > DotNetNuke® > DotNetNuke® Questions
Subject: Upgrade DNN 2.1.2 to use SQL 2k5
Prev Next
You are not authorized to post a reply.

Author Messages
davidATapr
Nuke Newbie
Nuke Newbie
Posts:7
13 Oct 2008 3:58 PM  
Hello,

We are currently using SQL Server 2000 with DNN 2.1.2.  We would like to upgrade to SQL Server 2005 so we can stop using SQL Server 2000.

So far I can successfully use a SQL Server 2k5 database for one of our portals, but I need to use the DNN database on 2k5, not 2000.

Our production db's and portals are using 2k so I can't really go into the current ones and just start modifying.

Any suggestions?  I'm assuming this is possible?

THANKS AND HAVE A GREAT DAY!!

Kind Regards,
David Henley
davidATapr
Nuke Newbie
Nuke Newbie
Posts:7
13 Oct 2008 3:59 PM  
Oh, and we can't upgrade to a new version of DNN because our custom modules are only for 2.1.2 and it would be way too much work to attempt new modules for us.
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3426
13 Oct 2008 4:01 PM  
Have you tried backing up the SQL 2000 database and then restoring it into the SQL 2005 server?

You should only then need to change the connection string to the server in the web.config file.
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
davidATapr
Nuke Newbie
Nuke Newbie
Posts:7
13 Oct 2008 4:10 PM  
Hi Lee,

Thanks for getting back to me. Our DNN and portal DBs are 2000 and I did a full backup then restore to 2005 without any problem. I noticed on the old connection string in the web.config file that the server was specified as an IP address. I changed the server to the name of our SQL Server 2005 server which is on the same server. I'm not that SQL Server saavy, but there wouldn't be a different IP for another instance of SQL Server on the same machine would there? I've been searching forums for most of the day and haven't made much progress.

I don't know if there is a way to change the Portal Root? Even with a different connection string, copy of the DNN folder, and a new virtual directory pointed at the new DNN folder, the portal page is trying to find modules from the old DNN folder.

Is there any possibilty of doing this another way? I'm pretty much at a stand-still right now.

THANKS AGAIN!!

Cheers,
David Henley
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2516
13 Oct 2008 5:42 PM  
If you have moved your web directory, you'll need to point IIS there.  If you've changed the URL of the portal, you'll need to adjust this in the PortalAlias table in your database.
Joe Craig
DNN Creative Support
Subscribe to the website
davidATapr
Nuke Newbie
Nuke Newbie
Posts:7
15 Oct 2008 8:15 AM  
Hello,

Below is a few paragraphs outlining some background, but my question is:

Can I take a portal in 2000 and update it to point to a DNN database and content database in 2005 while still keeping the same URL?

Our goal is to make the switch over to SQL 2005 invisible, so our URL is going to be the same. We have a test portal that I am using. I have made the data source for our modules point to this test db on 2005. Everything works fine so far. The new database is on 2005, but the DNN database is still on 2000 (i mean we haven't deleted 2k yet).

In our goal to move away from 2000, we need to move the DNN database over to 2005. I have backed up and restored the DNN database to 2005, so we are running a DNN database on 2000 and the exact same backup on 2005 with both of these running on the same machine.

We have 24 different portal sites running on 2000 so altering the current DNN database on 2k or the website that points to the DNN directory in Inetput isn't an option. The website points to a static IP with no host header.

Now what I have done is created a new website in IIS with a host header that points to our test URL and no static IP. This website also points to the COPY of the original DNN folder in Inetpub and not the original DNN folder.

I edited the web.config file in the COPY of the DNN folder to point to the 2005 SQL Server which resides on the same machine as the 2000 SQL Server.

The portal alias is still pointing to the test URL because we don't want to change the URLs, only change the databases over.

So when I delete the portal_id for our test portal from the 2000 version and browse to the test URL, I get an error saying that our modules can't be found in the original DNN directory. The reason I deleted this test portal from 2000 is because like I said 2k is going away. However, when I leave the portal_id folder in the DNN folder, everything works as normal.

Please let me know you need additional information or if any of this isn't clear.

THANKS !!

David Henley

jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2516
16 Oct 2008 12:14 AM  
It should work.

Backup your existing database, and restore it to your new database server. Edit web.config to point to the new database server. That should be it.

There is no URL issue because you aren't changing the website.

What am I missing in your description?
Joe Craig
DNN Creative Support
Subscribe to the website
davidATapr
Nuke Newbie
Nuke Newbie
Posts:7
16 Oct 2008 7:23 AM  
It almost sounds too easy.

You're not missing anything in my description. Basically we want to eliminate 2000 and go to 2005 with the same database, modules, everything.

I'll have to backup our current DNN folder or at least the web.config file and try it either real early in the morning or late at night to make sure our clients aren't using the portals. Hopefully that will work. Will post again if it doesn't.

Thanks,
David Henley
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2516
16 Oct 2008 7:43 AM  
I would suggest that you make a complete backup of both the website and the database, and then install on a test system.  You should only need to change the portalalias for one of the sites to verify that it works.
Joe Craig
DNN Creative Support
Subscribe to the website
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > Upgrade DNN 2.1.2 to use SQL 2k5



ActiveForums 3.7

Latest Forum Posts

RE: DotNetNuke News 8th Dec 08 by jncraig
Yes, I'm getting an error, also. But ... you can probably get the podcast from this link: http...
RE: Can't Login! Login Page can't be accessed... by jncraig
This table is part of your DotNetNuke database.You might first want to review these tutorials to hel...
DotNetNuke News 8th Dec 08 by pwadding
When I attempt to download the  Podcast I get an error message. Tried both servers. The first few li...
RE: Can't Login! Login Page can't be accessed... by e-kreator
a database that you mean.
RE: DotNetNuke 4.9.1 and 5.0.0 by jncraig
Yes, lots of learning, lots of new things and new ways.  I played a little with Beta6 of DotNetNuke ...
RE: PDF File Content by jncraig
If you want to just serve up the PDF files as PDF files, upload them using the File Manager.  You ca...
RE: Navigating between modules by jncraig
What is the URL that is generated? To which page does it send you?
RE: New Logo cant display by jncraig
There is nothing wrong with this, provided that you did it correctly.  I would have to look at your ...
RE: Child portal to live site by jncraig
You should set DNS to point the URL to the IP address of the DotNetNuke installation.  Inside of the...
RE: PopUp Page by jncraig
To open a link in a new window, format the link this way:Link to us! It is the target="_blank" that...
RE: How to Change fckeditor alignment by jncraig
It might be easier to use a different skin for your administrative pages. There have been some ot...
RE: Can't Login! Login Page can't be accessed... by jncraig
If you have access to your database, look at the Portals table.  Make sure that LoginTabID is set to...
RE: Can't Login! Login Page can't be accessed... by e-kreator
Hello my problem is that the configuration management in login page page was sent to a Web page that...
RE: Create new 'host' user? by jncraig
You can change a regular user to a Host, by setting the "Host" user's IsSuperUser set to True in the...
Create new 'host' user? by jonathanbrickman0000
I have a DNN 4.7 web site successfully migrated to a new server.  There is only one hitch:  the 'hos...
RE: split copyrgt option in two lines by jncraig
You can put a in the copyright text. This may or may not put other text (to the right of the copyr...
RE: Can't Login! Login Page can't be accessed... by jncraig
Try: http://localhost/DNN/login.aspx http://localhost/DNN/?ctl=login If neither of those ge...
RE: HOw to upload site from localserver to www.mysite.com by jncraig
View this tutorial:How to transfer a localhost DotNetNuke installation to a live websitePay special ...
RE: Nightmare with SKINS... by jncraig
Before you get in too far, you might want to take a look at:An Introduction to the Principles of Dot...
RE: Nightmare with SKINS... by dougieladd
Hi Joe...thank you for that...I kind of assumed that was the case. As I understand it the skin comes...
DotNetNuke Modules
RSS Feeds