Wednesday, November 19, 2008
 
   
 
How do I maintain a dev server for testing and not lose information?   Minimize
Location: BlogsOpenDNN blogOpen-DocumentLibrary    
Posted by: Xepient Solutions 7/26/2007
O-DL needs an extra step when you restore a DNN DB backup from one server to another. This article will show you how not to loose data.
  1. First modify the xsdl_RootFolderPath entry in the ModuleSettings table to your new Root Folder Path.
  2. Then execute this sql
     
    ---------------------------------------------------------------------------------
     
    declare @OldRootFolderPath nvarchar(256)
    declare @NewRootFolderPath nvarchar(256)
     
    --example
    set @OldRootFolderPath = 'c:\dotnetnuke\dotnetnuke4.5.3\portals\0\'
    set @NewRootFolderPath = 'd:\dotnetnuke\dotnetnuke4.5.3\portals\0\' 
     
    update  xsdl_Folder
    set  FolderPath = REPLACE(FolderPath, @OldRootFolderPath,@NewRootFolderPath)
    from   xsdl_Folder
     
    GO

    ---------------------------------------------------------------------------------
     
     
    AS IS. please check this code for correctnes. 
Permalink |  Trackback

Comments (1)   Add Comment
Re: How do I maintain a dev server for testing and not lose information?    By host on 9/25/2007
Hi, yes, it was tested in a webfarm environment and it was reported working.<br><br>Make sure you change the values in the @OldRootFolderPath and @NewRootFolderPath parameters before executing the SQL statement.<br><br>Regards,<br>Xepient Solutions <br>


Your name:
Title:
Comment:
Security Code
Enter the code shown above in the box below
Add Comment   Cancel 
     
Search the Blog   Minimize
     
Blog List   Minimize
     
Blog Archive   Minimize