Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Skins, Themes, ...Skins, Themes, ...Portal move problemPortal move problem
Previous
 
Next
New Post
11/16/2010 1:27 PM
 
I'm moving all my portals from one server to another. I've installed the same version of DNN community (05.05.01 (22)). I'm using the export-template with content method, then selecting that template when recreating the portals on the new server. I've installed all the same modules, same versions that are in-use. I've also installed the same version of the skins on the target server. Here are the differences in server technology:

Old server:
  • Windows 2003 R2 SP2, IIS6, .NET 2.0.50727.3615.
  • SQL Server Developer Edition (64-bit) 10.0.2531.0 SP1 (2008)

New server:
  • Windows 2008 SP2, IIS7, .NET 2.050727.4206
  • SQL Server Web Edition (64-bit) 10.0.2766.0 SP1 (2008)

I have a portal with 110 pages that uses a variety of installed modules, including "Links", "Announcements" and "Form and List". I'm creating the portal on the new server with the same PortalID that I used on the old server. Every time I try to create it, I get the error at the end of this message, and only 55 pages are imported. Besides this error, is there a log of the process that might show me specifically where the creation fails?

Here's the site running properly and live on the old server: http://www.AltamontVBC.com
Here's the new site that is incomplete: http://avbc.RadioActiveLamb.net


Error parsing Portal TemplateViolation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID, Int32 createdByUserID) at DotNetNuke.Security.Permissions.PermissionProvider.SaveModulePermissions(ModuleInfo objModule) at DotNetNuke.Security.Permissions.ModulePermissionController.SaveModulePermissions(ModuleInfo objModule) at DotNetNuke.Entities.Modules.ModuleController.DeserializeModule(XmlNode nodeModule, XmlNode nodePane, Int32 PortalId, Int32 TabId, PortalTemplateModuleAction mergeTabs, Hashtable hModules) at DotNetNuke.Entities.Tabs.TabController.DeserializePanes(XmlNode nodePanes, Int32 PortalId, Int32 TabId, PortalTemplateModuleAction mergeTabs, Hashtable hModules) at DotNetNuke.Entities.Tabs.TabController.DeserializeTab(XmlNode nodeTab, TabInfo objTab, Hashtable hTabs, Int32 PortalId, Boolean IsAdminTemplate, PortalTemplateModuleAction mergeTabs, Hashtable hModules) at DotNetNuke.Entities.Portals.PortalController.ParseTab(XmlNode nodeTab, Int32 PortalId, Boolean IsAdminTemplate, PortalTemplateModuleAction mergeTabs, Hashtable& hModules, Hashtable& hTabs, Boolean IsNewPortal) at DotNetNuke.Entities.Portals.PortalController.ParseTabs(XmlNode nodeTabs, Int32 PortalId, Boolean IsAdminTemplate, PortalTemplateModuleAction mergeTabs, Boolean IsNewPortal) at DotNetNuke.Entities.Portals.PortalController.ParseTemplate(Int32 PortalId, String TemplatePath, String TemplateFile, Int32 AdministratorId, PortalTemplateModuleAction mergeTabs, Boolean IsNewPortal) at DotNetNuke.Entities.Portals.PortalController.CreatePortal(String PortalName, UserInfo objAdminUser, String Description, String KeyWords, String TemplatePath, String TemplateFile, String HomeDirectory, String PortalAlias, String ServerPath, String ChildPath, Boolean IsChildPortal)
 
New Post
11/16/2010 2:58 PM
 

You should be able to just copy all the files from your current server to your new server.  Then get a copy of your database and bring it into your new sql server.
You will then need to edit the web.config on the new server to point to the new database / server.
In the dtabase, you will need to edit the httpalias values in the PortalAlias table to match your new urls.

that should do it.
 
New Post
11/16/2010 3:02 PM
 
Will that all work, even-though the SQL and Windows server names and physical paths aren't the same? I suppose I'll just give it a shot. Thanks.
 
New Post
11/16/2010 3:09 PM
 

As long as all the file permissions are in place on the new server and you change the web.config correctly.  I have done it a few times (especially when restoring to a development server)
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Skins, Themes, ...Skins, Themes, ...Portal move problemPortal move problem


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out