Register now or log in to join your professional community.
Good morning, I have a project that's built on MSSQL/ASPsince, my client wants to upgrade the platform to be on PHP/MySQL, what's the simplest way to bridge (not just migrate) or replicate the data between MSSQL and MySQL, since MSSQL is feeding several platforms that will stay active and PHP MSSQL is a bit slow and have several limitation I will have to use both.
That's an important question! I have done it once and it ain't that simple... I will guide you through step by step!
Check your server for the MSSQL plugins, they are available on microsoft for each php version you're using there is a plugin,
Create MySQL db and keep in mind that Chars, Arabic and the length of the data needs to be set on both databases correctly or they will be read in an unacceptable way.
create a script that reads from SQL to MySQL and set it in cron (to run automatically on specific times) or if the server is ISS the scheduler rather than cron job. (if you need a sample of the script message me it was a huge work to find the right context)
Good luck
