Dịch vụ lưu trữ Web và Cổ điển Trợ giúp

Moving MS SQL Databases to Plesk from Web/Classic Hosting

To move MS SQL databases from Classic or Web shared hosting to Plesk requires quite a few steps. The process is long, but not that daunting. If you follow the steps, you should be able to move your database without much issue.

We've broken out the process into the following subsections:

Getting the Old Database's Information

  1. Create a backup of the database (more info).
  2. Download the database backup file (BAK) (more info).

Moving the Backup into SQL Server Management Studio

  1. Download and install SQL Server Management Studio (SQLManagementStudio) and SQL Server Express (SQLEXPR) from Microsoft here.
  2. Launch SQL Server Management Studio.
  3. From the File menu, select Connect Object Explorer...
  4. In the Server name field, type Localhost\SQLEXPRESS.
  5. Click Connect.
  6. In the Object Explorer window, right-click Databases, and then select Restore Database.
  7. In the Source section, select Device, and then click ...
  8. Click Add, locate the BAK file, and then click OK.
  9. Click OK.
  10. Click OK.

Converting Your BAK into a SQL Dump

  1. Click + next to Databases.
  2. Right-click the database you restored.
  3. From the Tasks selection, select Generate Scripts...
  4. On the Generate and Publish Scripts wizard that displays, click Next to advance past the Introduction.
  5. Select Select specific database object.
  6. Select only Tables, Views, and Stored Procedures.
  7. Click Next to advance past Choose Objects.
  8. Note the File name where you're saving the new SQL file.
  9. Next to Save to file, click Advanced.
  10. From the Types of data to script menu, select Schema and data.
  11. Click OK.
  12. Click Next to advance past Set Scripting Options.
  13. Click Next to advance past Summary.
  14. Click Finish.

Moving Your SQL Dump to Plesk

  1. Create a new MS SQL database in Plesk (more info). We recommend using the same database name as your old database.
  2. Note the Database server that displays.
  3. Open your SQL file, which should open in SQL Server Management Studio.
  4. Copy all of the contents from the file that display.
  5. From the File menu, select Connect Object Explorer...
  6. Complete the following fields, and then click Connect:
    Field What do...
    Server name Enter your Database server.
    Authentication Select SQL Server Authentication.
    Login Enter your database's username
    Password Enter your database's password
  7. Under the remote MS SQL server you connected to, click + next to Databases.
  8. Right-click the database you created in Plesk.
  9. Select New Query.
  10. Paste the contents of your SQL file into the window.
  11. Click Execute.

Executing the query can take a few minutes. Once it's done, your database has been moved to your Plesk account.


Bài này có hữu ích không?
Cảm ơn về phản hồi của bạn. Để nói chuyện với một đại diện của dịch vụ khách hàng, vui lòng sử dụng số điện thoại hỗ trợ hoặc tùy chọn trò chuyện ở trên.
Rất vui vì chúng tôi đã giúp được bạn! Chúng tôi có thể làm gì thêm cho bạn?
Rất tiếc về điều đó. Vui lòng cho chúng tôi biết điều gì làm cho bạn bối rối và vì sao giải pháp không khắc phục được vấn đề này.