Moving DotNetNuke from SQL 2008 Express RC2 to SQL Server 2005

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.

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?

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...

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)