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,
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: