Monday, September 22, 2014

How to Converting MySQL to PostgreSQL

How to Converting MySQL to PostgreSQL


Using mysql2pgsql.perl Download:http://bitshare.com/?f=6nj7i05s


1.dump the MYSQL data,save to mysql.sql

2.execute:perl mysql2pgsql.pl mysql.sql pg.sql

3.import

psql -d dbName -h localhost -p 5432 -U postgres -f filePath



How to Converting MySQL to PostgreSQL

No comments:

Post a Comment