I may be being stupid, but I'm persistent...
The latest and greatest GoDaddy Hosting for DNN/Windows is Ultimate Web Hosting. It is nearly limitless, supports SQL Server 12, the latest asp.NET and comes with the Plesk Control Panel. DNN 7.0.6 installs automatically in a few seconds, and as long as you upload the 7.3.4 upgrade properly with FTP, the upgrade goes seamlessly and you have Awesome Cycles 7.3.4 up in no time... If you are starting fresh, that is great...
Those of us with legacy DNN installs have to figure out how to get our non-trivial databases moved over. Plesk 12 won't let you upload a back-up db. GoDaddy offers a work-around that has you install SQL Server Express 12 and the SQL Server Management Studio, locally, download your old backup file, generate a Query Script that includes Tables, Views, Stored Procedures along with schemas and your data that you then set loose on a naked db on the Plesk side. The problem is it encounters errors that us mere mortals cannot understand or fix. 20 Pages of errors; around 300 or so... I have done this complete process 4 times with zero success.
Am I missing something? I used the 'old' machinekey/decryptionkey since it has to follow the users' files... I can generate a new, virgin, perfectly working instance on the old 'Classic' side; I can even get my old instances upgraded to 7.3.4. Same on the Plesk side. I cannot get my old working db over to the Plesk side, though... Not a sound migration path at present.
I know lots of folks use Plesk. Is there some fundamental DNN/Plesk incompatibility at play? Has anyone had success with this script approach actually working? I can get a site to 'appear' but can never log in or navigate, even with some of the errors [they differ with db]
ALL of my sites are now running at 7.3.4 on 'Classic' hosting so there is no overwhelming urgency.
A sampling of the errors is included below.
Bob H.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
The module 'AddEventLog' depends on the missing object 'dbo.AddEventLogType'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'AddEventLog' depends on the missing object 'dbo.AddEventLogConfig'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'AddTab' depends on the missing object 'dbo.BuildTabLevelAndPath'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'aspnet_Membership_CreateUser' depends on the missing object 'dbo.aspnet_Users_CreateUser'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'aspnet_Profile_DeleteProfiles' depends on the missing object 'dbo.aspnet_Users_DeleteUser'. The module will still be created; however, it cannot run successfully until the object exists.
Msg 4121, Level 16, State 1, Line 1
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.GetFileFolderFunc", or the name is ambiguous.
Msg 4121, Level 16, State 1, Procedure vw_Portals, Line 7
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.FilePath", or the name is ambiguous.
Msg 208, Level 16, State 1, Procedure vw_PortalsDefaultLanguage, Line 3
Invalid object name 'dbo.vw_Portals'.
Msg 208, Level 16, State 1, Procedure vw_Files, Line 31
Invalid object name 'dbo.Files'.
Msg 208, Level 16, State 1, Procedure vw_PublishedFiles, Line 32
Invalid object name 'dbo.vw_Files'.
Msg 207, Level 16, State 1, Procedure Forum_vw_ForumUsers, Line 12
Invalid column name 'EnableDisplayInMemberList'.
Msg 207, Level 16, State 1, Procedure Forum_vw_ForumUsers, Line 6
Invalid column name 'EnablePM'.
Msg 207, Level 16, State 1, Procedure Forum_vw_ForumUsers, Line 7
Invalid column name 'EnableDisplayInMemberList'.
Msg 1088, Level 16, State 11, Line 1173
Cannot find the object "dbo.Files" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Files'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Files'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Files'.
Cannot insert explicit value for identity column in table 'FolderPermission' when IDENTITY_INSERT is set to OFF.
Msg 544, Level 16, State 1, Line 2
Cannot insert explicit value for identity column in table 'FolderPermission' when IDENTITY_INSERT is set to OFF.
Msg 544, Level 16, State 1, Line 3
Cannot insert explicit value for identity column in table 'FolderPermission' when IDENTITY_INSERT is set to OFF.
Msg 544, Level 16, State 1, Line 4
Cannot insert explicit value for identity column in table 'FolderPermission' when IDENTITY_INSERT is set to OFF.
Msg 544, Level 16, State 1, Line 5
Cannot insert explicit value for identity column in table 'FolderPermission' when IDENTITY_INSERT is set to OFF.
Msg 1934, Level 16, State 1, Line 16
INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
Msg 1934, Level 16, State 1, Line 1
INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
Msg 1934, Level 16, State 1, Line 1
INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.Files" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Files" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Files" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Files" because it does not exist or you do not have permissions.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK_FileVersions_Files' references invalid table 'dbo.Files'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_FileVersions_Files' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 547, Level 16, State 0, Line 1
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Folders_FolderMappings". The conflict occurred in database "ilpa11915", table "dbo.FolderMappings", column 'FolderMappingID'.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_Folders_FolderMappings' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK_Forum_Attachments_Files' references invalid table 'dbo.Files'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_Forum_Attachments_Files' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 547, Level 16, State 0, Line 1
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_ModulePermission_Users". The conflict occurred in database "ilpa11915", table "dbo.Users", column 'UserID'.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_ModulePermission_Users' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 547, Level 16, State 0, Line 1
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_TabPermission_Users". The conflict occurred in database "ilpa11915", table "dbo.Users", column 'UserID'.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_TabPermission_Users' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.