How to import MSSQL database dump from Plesk into local MS SQL server?

user_2429678 0
Viewed 2295

I have a plesk acount and an MS SQL database from wich I got a dump through this interface they provide:

enter image description here

So I downloaded the dump file but it does not come as a .txt file but it comes without any extension and when I try to import it in my local MS SQL Server it fails always.

enter image description here

And when I try to open the dump file with notepad it shows weird characters(see picture below).

What am I doing wrong ?

enter image description here

import dump sql-server-2008 sql-server
2 Answers

I got it to work by extracting the dump file from the zip and renaming it with a .bak extension. Then did a Database restore in MS SQL Management Studio and selected this backup file (.bak). Hope that helps.

user_26496350

I finally found my way using a php script found on github I had to fork it to update couple things cause it became obsolete.

I had to go this way for couple reasons:

  • I didn't have admin access to the plesk server to enable remote DB access
  • I wasn't able to export it into any format readable by mysql

So with the php script i could load it unto the server and run it, The script copies an MSSQL into MySQL. Here is my fork.

user_24296780
Related