Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have DNN installation on SQL Server 2008 (R2).
I am changing my hosting to another web hosting company where SQL Server 2005 is the only option. Right now I have db backup (.bak file) & all DNN folders. Is it possible to downgrade the database version to SQL Server 2005?
If yes, can someone jot down the steps for me? If not, whats the backup plan if I have to stick with SQL Server 2005?

share|improve this question

migrated from Aug 25 '11 at 14:38

This question came from our site for professional and enthusiast programmers.

up vote 3 down vote accepted

Restore SQL Server 2008 DB *to* SQL Server 2005

I highly suggest Redgate Tools for this. SQL Compare and SQL Data Compare should do the trick.

share|improve this answer
After downgrading the database, and pointing connection string to it, would DotNetNuke work fine? Or do I need to make any other changes? – Alexander Aug 25 '11 at 0:49
That should work just fine. ADO.NET doesn't really care 2005 vs. 2008. What really matters is whether the stored procedures are using 2008-only functionality, and it is my understanding that DNN SP's are backwards compatible to 2005 – Brian Webster Aug 25 '11 at 1:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.