PostgreSQL to mysql

Discussion in 'MySQL' started by TibeDesign, Mar 2, 2008.

  1. #1
    any one know if its possible to change PostgreSQL to mysql if so hows it done?
     
    TibeDesign, Mar 2, 2008 IP
  2. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Yes it is possible, it is generally done by someone who knows both and can read through the queries etc and convert them where necessary
     
    AstarothSolutions, Mar 2, 2008 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    If you are able to export your postgre to a standard sql dump, then you may be able to import it into mysql without much editing. Sometimes it is necessary to alter the insert statements or data types, but usually this is the best way to do it.
     
    jestep, Mar 3, 2008 IP
  4. graformix

    graformix Member

    Messages:
    92
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #4
    You can try conversion tools from dbconvert.com
     
    graformix, Mar 10, 2008 IP