Learn DNN / DotNetNuke

You need to Register for free and Login to post a message in the forum.

Forum

Forums
Search Forum
Advanced SearchTopicsPosts

Forums > DotNetNuke® > DotNetNuke® Questions

Migrate content between servers?

Last Post 08/31/2010 7:38 AM by Joseph Craig. 7 Replies.

Sort:

Check this box to subscribe to this topic.	Prev Next
You are not authorized to post a reply.

Author

Messages

cube consulting

Nuke Ace
Posts:45

08/29/2010 10:45 AM
Hi, I had my DNN installation crash at one hosting provider and am now trying to move my content to another hosting provider... I downloaded the trial version of Redgate's SQL compare tool and managed to compare and synch all objects to the new hosting provider, but my actual pages lay-out and their content are not migrated..?!?! Can anyone tell me how to do this? Thanks Aad

Joseph Craig
DNN MVP
Posts:11667

08/29/2010 11:25 AM
It would be a lot easier if you could just move the database. It's hard to know what you might have missed. Does any vestige of the site appear?

Joe Craig, Patapsco Research Group Complete DNN Support

cube consulting

Nuke Ace
Posts:45

08/29/2010 12:03 PM
Are you saying just backup database one from hosting provider one and then restore on hosting provider 2 as database two? That I could do.. Aad

Joseph Craig
DNN MVP
Posts:11667

08/29/2010 1:08 PM
Yes. You will also need to adjust the PortalAlias table in the restored database. You will also need to edit web.config to connect to the new database. You will also need to move a complete copy of your web directory to the new server first.

Joe Craig, Patapsco Research Group Complete DNN Support

cube consulting

Nuke Ace
Posts:45

08/29/2010 2:27 PM
Hey Joe, So basically it is the same procedure as with moving a live database down to a localhost server, right? I mean judging by the tutorials.. I looked in the database using sql management studio and I see all the content is in there, but when I use SQL compare all runs well except the getHTML stored procedure. Is this the SP that sends over the content by chance?

Joseph Craig
DNN MVP
Posts:11667

08/30/2010 7:40 AM
Yes.

Joe Craig, Patapsco Research Group Complete DNN Support

cube consulting

Nuke Ace
Posts:45

08/31/2010 3:31 AM
Hi Joe, I think one crucial step is missing in the tutorial around this topic, which is relevant only when you want to migrate your contents to another live server with a hosting provider. Do you restore to a new database or can you restore to an existing database? I did both, and in the latter case (existing db) the restore seemed to add duplicate tables, and in the former (new db) it seemed okay, but content was not migrated..!? I did a local back up and looked at the tables, all contents were in there. I restored the database and then the content was not visible.. Aad

Joseph Craig
DNN MVP
Posts:11667

08/31/2010 7:38 AM
You should set up SQL Server Management Studio to overwrite an existing database. As for the case of content "not being there" I've not seen that. If all of the tables are there, you should not be having a problem.

Joe Craig, Patapsco Research Group Complete DNN Support

You are not authorized to post a reply.

Forums > DotNetNuke® > DotNetNuke® Questions

Latest Forum Posts

Can you Run Xcode in Linux? by Aman Singh

Can you Run Xcode in Linux?

Can you Run Xcode in Linux? by Aman Singh

Can you Run Xcode in Linux?

Billed for subscription that was canceled by Ryan

I was just billed for a subscription that was canc eled / inactivetive how do I get a refund for th

Meta Title and Meta Description are not showing properly by DNN User

Hi, On my site the meta title and meta descriptions are not showing properly. It's showing the m

Search is not functioning properly by DNN User

Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea

Search is not functioning properly by DNN User

Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea

DNN Platform import site optio by Melanie Weaver

Is it possible to import site template in DNN Platform 8.0? We have internal Evoq Content 8.1 tha

Events Module for DNN V5? by Tugboat

Would anyone have a download link for the version 5.0.3 Events Module? Thanks!

"Ghost" TabID Number? by Tugboat

Hi! I have a portal instance with multiple child portals and on one of the child portals, there i

RE: DNN Load Testing by ayman sharkawy

Hi. Have you already implemented a site using the DNN . And how the performance of the site and its

Publish All Pages by NSUOK

I'm using DNN Evoq Content Basic 8.2.0. When I make the HTML Pro module display on all pages, I h

Simpler profile needed in 9.2.2 by Donald

We are upgrading a DNN 4.8.4 site to DNN 9.2.2. On 4.8.4, the top bar shows the user’s name. If yo

How to link from dnnmodal popup to web site page? by Donald

Hello all. I am using a dnnmodal.show popup. The popup works correctly, showing the content that I

RE: Document Collaboration by Nick Davern

That feature would be super beneficial for our needs as well! Does anyone have an update as to if th

RE: DNN 9.2, how to set default theme? by Andy Stephenson DNN Creative

you do that under "Manage/Themes". Note the highlight blue border around the default container and d

DNN 9.2, how to set default theme? by Donald

Please disregard, found Manage Themes I cannot find how to set a default portal theme in DNN 9.2

RE: Looking for DataSprings Dynamic Forms by Andy Stephenson DNN Creative

Your best chance would be to contact Chad Nash @ http://www.datasprings.com/

Looking for DataSprings Dynamic Forms by Jakir HM

Looking for DataSprings Dynamic Forms 3.4 for DNN 4.x 5.x for my site (https://themasters2018s.com/)

RE: Help with Cycle Image Carousel not displaying images by peter

I had the same problem with the Will Strohl Content Slider after upgrading to DNN 9.1 The above an

RE: Object reference not set to an instance of an object by Andy Stephenson DNN Creative

Check this one might be useful: http://www.dnnsoftware.com/answers/im-tryin-to-move-my-site-to-pr

Used
By

Testimonials

| The SoloCoder Podcast | Google | Privacy Statement | Terms Of Use