Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Aug 25 '11 at 14:38

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

1 Answer 1

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 –  George W Bush Aug 25 '11 at 1:02

Your Answer

 
discard

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.