• Halloween is coming! To celebrate the occasion, we dusted off a couple of old skins, and even created a brand new one (Pixel).
    To get into the festive spirit, install the Skins extension.
  • The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

Question MS SQL DB migration: Windows to Linux

T

Tech Support

New Pleskian
Hi All

I am migrating a website from an old Windows Plesk server to a new Linux Onyx Plesk server. The website has a MS SQL database hosted on an external MS SQL DB server. What is the best approach on getting that database to work on the new Linux server? I can provide more info (versions, etc) after a meeting I have. Currently, the best I have is to pay a developer to convert it to MySQL , but some argue that, that isn't even possible. Thanks.
 
This seems to be a question not related to Plesk, but more to a MySQL format issue. For many data field format types, a dump of the old database and an import into a MySQL database will work. There is not problem with simply testing it. Simply create an SQL dump from your MS SQL and import it into MySQL. If it does not work, the import will tell you exactly what needs to be converted.
 
I am not aware that there is a MS SQL version for Linux. I think all MS SQL servers require the MS Windows OS.
 
Ah, I see that the SQL Server 2017 Express has a version that can be installed on Linux. It is the latest MS SQL server and only this one has a Linux version. Interesting. Anyway, this would need to be installed outside and in addition to Plesk and their database. You simply need to choose a different port thhan the port of MySQL/MariaDB on Linux to run a second database server parallel to another one.
 
You must log in or register to reply here.

Similar threads

T
Question Need clarification on quota management in service plan
Replies
6
Views
4K
Kaspar
K
T
Issue Database restriction on linux server
Replies
1
Views
2K
Sebahat.hadzhi
Sebahat.hadzhi
T
Question Clarification on different port using in plesk
Replies
2
Views
2K
Thomas Oryon
T
N
Resolved plesk without local db
Replies
1
Views
1K
nMLxTMJTZ
N
H
Question Can't Export DBs, SQL Assertion Error
Replies
0
Views
2K
hostking
H
Back
Top