All geek questions in one place

If you do not have your own database engine, what is the best way to convert the database to mysql?

I work for a very small company. I recently came across the question of whether there is a good way to convert a proprietary database to a MySQL database without owning its own database engine, for example. if you are given a large oracle database file (or select your favorite database database format), but it does not have a license for the oracle kernel engine, is there a good, completely reliable way to convert it to a MySQL database format that can be read using MySQL database engine? My question is very vague about which proprietary format is the source only because there will be many sources, and it looks like they will be "different and different." My suspicion is that there is no absolutely reliable way, especially for a wide range of patented databases.If there are several proprietary formats for which this is possible, I will still be interested to know, although “different and different” is probably the real problem. Minimizing costs, effort and proper conversion are key, so I think this is probably on a list that is not available.

-John

+3
source share
3 answers

Most commercial databases have a trial version or a limited download version, at least should be enough to export data and schema.

However, you do this, it is probably safer to read the schema and create the structure in MySQL, and then export each table, as CSV says, and re-import it into MySQL, rather than relying on the direct conversion tool.

ps. Of course, if you have a lot of stored procedures or special SQL-specific SQL, then it will hurt a lot more!

+6
source

( ) SQL DDL/DML. , . MySQL PostgresSQL ​​. Microsoft SQL Server. Oracle . , , .

, BLOB . , , . , SQL- //, , SQL.

0

Oracle Personal Edition ( Windows). (, ) [ 100 ] , Oracle .

, . , , , Personal Edition ( ). Oracle . .

0

Source: https://habr.com/ru/post/1749951/

More articles:


All Articles