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...Upgrading DNN P...Upgrading DNN P...Plesk, MSSQL, GoDaddy and DNN...Plesk, MSSQL, GoDaddy and DNN...
Previous
 
Next
New Post
1/25/2015 10:27 AM
 

Circling back...  Got it figured out, kinda.  Not working, but figured out.

Machinekey settings were correct; they must always follow the db contents/data.  This has not changed, and the keys had nothing to do with the inability to log in for this case...

I got time to poke around the post-migration db and found some serious issues in the DNN USERS table.  The aspnet tables were fine, but the DNN Users table was nearly totally blank [only a handful of records vs 500 expected and in the original].  Re-transferring just the data for that table alone cleared the login problem.  Other issues remain...

Other tables are likewise totally blank.  They were tables beginning with V or W and came after the Users table in the script 'data insert' section [very near the end of the 120,000 line script].  It was like the script just gave up and quit, yet it said it was complete, but with errors; I believe the SET IDENTITY_INSERT errors dealt with those tables...  Those errors did not occur when the identical section of script was executed alone, though, and the script does not appear to have been incorrect... [i.e. the error report was in error, but who knows w/o valid line numbers, SSMS sucks in that respect...].  [Disclaimer:  I'm not a programmer...]

My conclusion is that DNN is fine and Plesk is fine [I really like the collection of tools a lot], but that the 'script' migration process between db servers as a whole is fundamentally flawed.  I am not certain the results would be the same if I ran it again, identically.  Perhaps running it remotely is the problem; no ability to check for or correct errors in the result [the process is open-ended and obviously error-tolerant].

Migrating to GoDaddy Web/Plesk Hosting is highly NOT recommended at this time [scripting your db in is the only way to get it to the db servers as the Plesk 'upload' feature is off and appropriately so].  It would be my candidate of choice if I was starting anew with a client/site, though, mostly due to the superior Plesk tools.

I will try again in a few weeks or months; I may try breaking the script into pieces; I may not bother...

Bob

 
New Post
1/25/2015 10:35 AM
 

@ Richard Howells

You were/are indeed correct.  Your reply saved me a lot of time chasing that one...  THANKS.

 
New Post
2/12/2015 12:41 PM
 

After 4+ weeks and countless attempts at scripts, import/exports, directly connecting db's and failed copy's, GoDaddy has acknowledged that an existing site with stored procedures, UDFs, and such [i.e., a non-trivial DNN install] cannot be migrated from their old servers to their new servers without effectively a rebuild of the db on their new server environment.  To get your local db to their new server environment the scripting that is part of SSMS [Management Studio] is to be used and their provided procedure.  The procedure yields highly inconsistent results [lost/missing data; sometimes complete tables lost].  The only consistency has been a failed migration. ZERO success in dozens of attempts.

They claimed the procedure works for them, so I tried it with a virgin DNN install of Awesome Cylces; no joy...

My quest began when I had to upgrade my hosting to run DNN 7.0.0 or later, only to find I could not take my db with me...

GoDaddy today issued the following response, which should scare the pants off any customer with an existing DNN site hosted there.

Support Staff Response

Dear Bob ,

Thank you for your response.

I understand you are having issues with the import of your .bak file. You can only restore a .bak file to the hosting account it was originally created with, if you make a backup of the .bak file in an alternate account, you are still not able to restore it by uploading it to an alternate account. To clarify you are able to install the Express version of SQL Server Management Studio to accomplish this task, you do not need to install the full version.

You will need to import the database to the local database that is installed with SQL Server Management Studio and then import it to the database on file. In our previous incident we explained that some features can not be migrated to alternate Shared Hosting environments, this would include Stored Procedures, Schemas, Triggers, etc. If these are a part of your existing site they will need to be recreated in a Shared Environment database on the new hosting account.

At this time Classic Hosting is no longer offered in the hosting environment as this is an outdated technology and we are working to have customers upgrade to the latest versions of software. The ability to import a .bak file with the additional features is possible but for this type of access you would need to obtain a Virtual Dedicated Server as you are granted more access to use more features.

Please let us know if we can assist you in any other way.

Regards,
Brandon P.
Professional Hosting Services


I believe GoDaddy will see the error in their logic since I cannot afford to rebuild, or a VDS.  Perhaps others will conclude similarly.

 
New Post
4/21/2015 12:22 PM
 

Wanted to close this out, for anyone who cares...

After working with Chris Onyak of OnyakTech.com and his new Ninja Backup software, he discovered that GoDaddy simply did not provide sufficient rights to all of the db components necessary for backup and restore of the db between their old and new platforms.  I have to admit I gave up long before he would, but he eventually gave it up.  All was not lost since in the process we discovered his User Export/Import worked flawlessly [once you clean up the spurious commas in the CSV  formatted i/o file], a key element in the ultimately completed migration.

The other big win was the almost complete portability of the instance [except for users] thanks to iPortable DNN modules; emphasis on almost.  Although the links module is supposed to be iportable, and it tried to be, the links really got scrambled in the process.  I wasn't surprised based on previous failures but it looked more promising this time; up until the end.  It wasn't to be, though...  I bit the bullet and converted the 700+ links entries to HTML-module entries using cut-n-paste and have sworn off ever using the Links Module again...  The HTML modules and all data made the trip flawlessly.

Once rebuilt on the Plesk side, the site is quite responsive, and a salient advantage is that once built, the site can be made ROOT using the Plesk console, resolving a big GoDaddy drawback from the past.

If you are migrating DNN sites between GoDaddy servers, don't count on them for any help, and don't trust their 'script' and SqlServer Management studio approach without very careful testing.  Microsoft doesn't help much and their *.bacpac solution, though sounding almost perfect, won't help much with a GoDaddy source db due to rights issues.  They might be more helpful if migrating to Azure, though.

Kudos to iPortability [except for Links...] !!  DNN still Rocks!

Bob H.

 
New Post
4/21/2015 12:35 PM
 
Hi Bob thanks for documenting this for the next guy who comes along.

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Plesk, MSSQL, GoDaddy and DNN...Plesk, MSSQL, GoDaddy and DNN...


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