Moving DotNetNuke from SQL 2008 Express RC2 to SQL Server 2005

garion1
garion1 used Ask the Experts™
on
I need to move a DotNetNuke installation from one website host to another. The existing DB is on SQL 2008 Express RC2. The target server runs SQL Server 2005.

I know it is possible to restore a SQL 2008 Express DB in SQL 2005?
Is there a special way to do the backup in 2008 so that it is compatible with 2005?
What is the process?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
I found this link: http://www.hyper-v-mart.com/HowTo/Convert_SQL_Server_2008_to_SQL_Server_2005.aspx

I am going to try this. If it works, I will leave this question here for others to benefit.

Author

Commented:
Our web hosting company says they cannot run a SQL script to restore the database and need a "dump" of the database which they can then import into the new databse created for me on the target server.

How do I create a dump of a database?
ValentinoVBI Consultant
Most Valuable Expert 2011

Commented:
I assume that by now you already found out that backups from a higher version cannot be restored to an earlier release.  So that's not an option.

With "dump", maybe they're referring to a bulk-copy export?  (also known as BCP)  See also http://msdn.microsoft.com/en-us/library/ms187042.aspx

Or, another way to dump your data is by using the Import/Export Wizard.  In the Management Studio, right-click your DB, choose Tasks > Export Data...
Not 100% sure if this exists in the Express edition though.

But erm, if I were you I'd look at finding a better host.  One that is using SQL Server 2008 and allows you to execute scripts.  I'm using a really cheap host for my blog and I have full control over my DB...

Commented:
An alternative would be to use db synchronization software such as RedGate SQL compare / datacompare or equivalent applications (eg. search google : http://www.google.com/#sclient=psy&hl=en&q=sql+comparison+tools&aq=f&aqi=g2&aql=&oq=&gs_rfai=&pbx=1&fp=6cd6d4c3e6deab23)
 
Commented:
Thanks for the advice.
Our current hosting company has struggled to get this right. We exported a script file and specified the target db as SQL 2005. They tried to import it their side to no avail.
We found a hosting company which can do the job but their monthly hosting costs are ridiculous.
We are going to leave the site on the existing server as this move is too much of a headache.

By the way, I found another usefull link on this subject:
http://www.devx.com/dbzone/Article/40531/0/page/1

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial