V
V
Vladimir Mogilev2018-09-13 10:23:39
MySQL
Vladimir Mogilev, 2018-09-13 10:23:39

How to migrate from mssql to mysql using doctrine orm?

The essence of the problem:
By cron or direct call, you need to run a script that will check certain tables in 2 databases. The base from which MsSQL data is taken and it is necessary to pour them into MySQL.
Since the project is in symfony, doctryne is used. So I'm wondering if there are any regular methods that will help to do this?
Important notes:
- the command was executed

bin/console doctrine:mapping:import App\\Entity\\MsSQL annotation --path=src/Entity/MsSQL --em=mssql
and the whole mssql structure was created
- I would strongly like to set new table names in MySQL (different people finished MsSQL and there is anarchy in the names, I would like to avoid this myself)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Ivan Shumov, 2018-10-03
@inoise

Database Migration Tools are tools for this task. Look at ready-made solutions

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question