current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote -3 down vote favorite

In my system I want to migrate my full database from mysql to postgresql

mysql> SELECT VERSION();
+--------------+
| VERSION()    |
+--------------+
| 5.1.73-1-log |
+--------------+
1 row in set (0.02 sec)


shell=# SELECT version();
                                           version                                            
----------------------------------------------------------------------------------------------
 PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit
(1 row)

Is it possible to convert my full database using any migration tools or using any php or perl script?

In mysql I have three views also which I also want to convert into postgresql tabes using this migration also.

share|improve this question
    
If this were my problem, I would be the tool. –  Dan Bracuk 2 hours ago
    
i had made full script for it for migration but its not work fine each time even in that i made put all debug points but its not work fine for millions of records after some millions of records its stop working automatically without leave any debug points so i am not able to trace my script so i thought that kind of solution for it –  Ankit Doshi 2 hours ago
    
I would do it manually. –  Dan Bracuk 2 hours ago
    
yeah that is good idea but when we have millions of records so that time how we can know about error point today i got in mysql table 1,37,00,000 records and after 22,00,000 its stop working automatically so i cant get any idea why this happened ? i have made block of 1000 records and do it same as it –  Ankit Doshi 2 hours ago
    
Usually the easiest way: create the approriate DDL script to setup the tables in Postgres (can be done with some intelligent search & replace from the MySQL scripts you have). The export the data as CSV files and import them into Postgres. –  a_horse_with_no_name 2 hours ago
add comment

1 Answer

up vote 0 down vote

I'm not sure but you can look pentaho Spoon Data Integration. its free tool and i saw using this tool for migration db2 to sqlserver. Maybe you can use pantaho

download link:

http://community.pentaho.com/projects/data-integration/

here is documentation of spoon:

http://wiki.pentaho.com/display/EAI/Latest+Pentaho+Data+Integration+%28aka+Kettle%29+Documentation

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.