Mysql to Postgresql Convertor

Zain Reza Merchant 0
Viewed 37

Is there any function in PHP where we pass MySQL query syntax and return to PostgreSQL query syntax?

like

we have no date_format in PostgreSQL. so i pass the query with date_format of MySQL query syntax and get PostgreSQL query syntax

mysql postgresql php
1 Answers

The prospect of migrating a database can be intimidating, especially when migrating from one database management system to another. pgLoader is an open-source database migration tool that aims to simplify the process of migrating to PostgreSQL. It supports migrations from several file types and RBDMSs — including MySQL and SQLite — to PostgreSQL.

If you have not large tables, or not many functions or procedures, You can use DBeaver. DBEaver - Free and Open-Source Universal Database Administration Tool, supports almost all Databases. For using DBEaver you can export from MySQL and import to PostgreSQL all your tables. This option is simpler and easier, but not for big data.

Ramin Faracov0
Related