Migration sql server tô mysql php app

how to migrate a php application from sql server to mysql? What are the methods? the method I'm using is to migrate the database first and then change the codes. Is there any method or company specialized in this type of migration?

MohamedTammam

3 years ago

Level 51

If you didn't write your own queries, then it should be easy since Laravel supports both: https://laravel.com/docs/9.x/database#introduction

You just need to change you env DB_DATABASE to mysql.

But if you wrote your own queries, then you need to adjust them as well.

jlrdw

3 years ago

Level 75

Backup all first.

You should be able to use MySQL Workbench to handle exporting and importing the data.

The code, I have no idea. It depends on:

Is it currently laravel
Is it straight PHP

rgpsico

3 years ago

Level 3

@jlrdw is php vanilha 😭😭

Sinnbeck

3 years ago

Level 102

@rgpsico then you will sadly need to rewrite every single query, unless some sort of orm was used

Maybe it would be an idea to redo the app in laravel so it's future proof?

1 like

Please or to participate in this conversation.