We have real old server running DTS packages and SSMS 2008 or older. We need to transfer our DB to new server that can also run PHP applications. What do I need to do to set it up?
Thank you,
Asked
Active
Viewed 34 times
0
-
(1) Is it true that you already have a system in place (written in PHP) accessing the data in the MS SQL server ? (2) If not, what are the reason(s) that you want to migrate the DB to one which can run PHP ? – Ken Lee Jan 07 '23 at 00:19
-
It's an old server vulnerable to hacking. – Kaur Jan 07 '23 at 00:26
2 Answers
0
- I prefer Ubuntu for a long time, so I would install the latest Ubuntu version on a server.
- I would use apt install to install mysql and php8.
- Dump the old database to file and copy it to new server.
- Import the new database.
WoodyDRN
- 1,221
- 20
- 26
0
If you are using an old Win server that is vulnerable to hacking and wish to replace it with a new one (capable of running PHP), broadly you have two choices:
Windows Server
a) You may stick to using Win server OS and upgrade the db version and server OS to the latest version (SQL Server 2022 and Win Server: 2022) , then if you wish to run PHP on the machine, you may install it thru Microsoft Web Platform Installer so that the machine will be one with IIS capable of running PHP. For details, please refer to MS site:
Linux Server
b) you may choose to set up a linux server which is capable of running PHP/MySQL, and migrate the existing MSSQL database (as you have specifically mentioned) to MySQL thru some sort of migration tools
For setting up a linux server capable of running PHP (aka LAMP), you may refer to the following link (and others)
https://superuser.com/questions/993316/how-do-i-set-up-a-lamp-server-from-scratch-using-centos-6-7
For migrating the MSSQL to MySQL, you may refer to this SO post for some reference / information:
Ken Lee
- 6,985
- 3
- 10
- 29