I have a DotNetNuke site currently residing on a Windows Server 2003 VPS running under MS SQL EXPRESS 2008. I would like to move this site to a reseller host running under HSPHERE and MS SQL 2005. (so no, a simple BAK file does not work).
I can provide remote admin connection to the VPS and external SQL access to the reseller site using something like EMS SQL Manager.
I've tried generating the scripts to transfer the data across but can't quite seem to get it to work, I must be missing something in the editing of the scripts around db owner/login etc. I could keep messing around with it but would rather have it done 'right' than just my 'attempt'
Site is running DNN 5.6.1. I can simply FTP over the site files and have permissions set so that is not the big issue rather than getting the DB transfered properly.
There could end up being additional transfers to the bidder if this one goes smoothly.