I have an existing DNN site that I want to migrate to NS but I have hit a roadblock trying to figure out how to upload a SQL backup of the existing site and then restore it to my NS SQL Server. (BTW - the set up guide shared by Charles Self at Narrowgate was immensely helpful installing DNN on NS.)

Here are the roadblocks I have encountered.

1) On my SQL info page (Web Hosting>>Manage Web Hosting>>Configurations>>Database Manager), there is no DSN, username or password shown (regardless of the show/hide setting) so I can't connect via SQL Server Managment Studio. Only the server name is displayed. If I select the database and click on Edit there is no additional information on this page either.
2) I get an "Access denied" error (550) trying to upload a SQL bckup file to my NS SQL backup directory. Even if I was sucessful uploading a backup, since the physical file name on the old SQL server is different than the NS path, it will have to be changed prior to executing the restore. (I assume someone at NS would do this.)
3) Customer service has been completely non-responsive.

NS seems new to hosting DNN. Has anybody migrated an existing DNN site to NS? I would love to get some feedback on how you did it.

Thanks in advance.

MikeVan,
Have you figured out a solution yet?

Also, thanks for the comment on the doc I posted a while back!

Charles Self
Narrow Gate Solutions

www.narrowgatesolutions.com
dotnetnuke.narrowgatesolutions.com - DNN Related Resources
twitter.com/chuckself

Thanks for the reply.

The info for 1) was in the web.config file, of course. I completely spaced that one.

As for 2) I did get a reply from support eventually. They advised me to upload a .bak file to the htdocs folder and then submit a request to them to transfer the file to the SQL backup folder. I uploaded the bak file but NS Support hasn't transferred the file over to the correct folder yet so I can't restore it yet.

There has to be an easier/faster way to do this. I have been looking for a better process. I found ()BackupScript 3.1.0 for DNN4/5 & GoDaddy on Snowcovered it looks like it would automate this process. They claim to be compatible with all the major hosting sites. The SQL tools at Redgate look useful too. Any experience with either of these tools?