A2 hosting database migration problem

Hi,

as many of you knows, A2 hosting has serious problems since last security breach with ransomware. Since they still did not allowed database backup, there is big problem to migrate Nop site to other hosting.

If there is someone who needs help, we can provide one for free by sharing usefull suggestions....

Just send us message to PM or reply to this post.

Regards,
Dario

======================
To generate a database script with SSMS:

1. Open your SSMS
2. Connect to your remote SQL server using your database login details
3. Right-click on the database you wish to backup and select Tasks -> Generate Scripts. This opens a Wizard.
4. Hit Next on the Introduction screen
5. Leave the default "Script entire database and database objects" selected and hit Next
6. Click button Advanced and change "Types of data to script" from "Schema only" to "Schema and data".
7. Hit OK
8. Select the option to "Save to a new query window" and hit Next, Next and Finish
9. Copy the script to your local file and store or run wherever needed. The backup will be in .sql format.

To restore that scripted backup at your local end, refer below steps :

1. Open your SSMS
2. Click on New Query
3. Copy and paste the query from the .sql file in that query window.
4. Modify the restoration paths of .mdf and .ldf files as per the location paths of these files on your local SQL server.
5. Click on Execute
6. It will take some time to execute the query. It depends on the database size.
===========================

Good post!