On 02/22/11 1:25 AM, Jaime Crespo RincÃn wrote:
2011/2/22 Adarsh Sharma<adarsh.sharma@xxxxxxxxxx>:
Dear all,
Today I need to back up a mysql database and restore in Postgresql database
but I don't know how to achieve this accurately.
Have a look at: "mysqldump --compatible=postgresql" command:
<http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_compatible>
Anyway, most of the times you will need a more manual migration, with
human intervention (custom scripts) and migrating the data through
something like CSV (SELECT... INTO OUTFILE).
if your tables aren't too huge, one method is via a perl script that
uses DBI to connect to both mysql and pgsql, and fetches a table from
one and loads it into the other. the catch-22 is, its fairly hard to
do this efficiently if the tables won't fit in memory
there are also various "ETL" (Extract, Translate, Load) tools that do
this sort of thing with varying levels of performance and automation,
some free, some commercial.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
