Is the correct way to populate my database in Plesk using their Database tab, SSMS, My Little Admin, or some other way?

314 Views Asked by At

I cannot find much in the way of written instructions on how to copy my database to Plesk.

This page simply says, "To create a database and a database user: Go to Databases > Add Database."

And then it shows a screenshot which does not match what I have; specifically, it shows an "Import Dump" button which I do not have:

enter image description here

This is what I see in my session (no Import Dump button):

enter image description here

I zipped a .bak file of my database contents and uploaded it to the File Manager's Files section:

enter image description here

...but how do I move it from there to the Database area, and what do I then do to populate my tables with the contents of the .bak file?

Is this something that should be done using Microsoft SQL Server Management Studio, or from "My Little Admin," or what?

I was able to create the (empty) tables by running a script.sql file I generated from my local database. My Little Admin indicates that the empty tables do exist on the server, for example here is the ACTORS table:

enter image description here

OTOH, SSMS shows that the database exists, but shows no tables:

enter image description here

0

There are 0 best solutions below