Re: [GENERAL] Mysql to Postgresql

2011-02-24 Thread Linas Virbalas
2011/2/22 Adarsh Sharma : > 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. In addition to other suggestions, you could also use open source Tungsten Replicator which has real-time MySQL to PostgreSQL repl

Re: [GENERAL] Mysql to Postgresql

2011-02-23 Thread Andy Colson
On 2/22/2011 9:33 PM, John R Pierce wrote: On 02/22/11 1:25 AM, Jaime Crespo Rincón wrote: 2011/2/22 Adarsh Sharma: 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=po

Re: [GENERAL] Mysql to Postgresql

2011-02-22 Thread mezgani ali
Please take a look at this article: http://securfox.wordpress.com/2010/12/12/converting-mysql-to-postgresql/ I think also, that there are a tool that can do this easly, Regards, On Tue, Feb 22, 2011 at 9:21 AM, Adarsh Sharma wrote: > Dear all, > > Today I need to back up a mysql database and res

Re: [GENERAL] Mysql to Postgresql

2011-02-22 Thread John R Pierce
On 02/22/11 1:25 AM, Jaime Crespo Rincón wrote: 2011/2/22 Adarsh Sharma: 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:

Re: [GENERAL] Mysql to Postgresql

2011-02-22 Thread Jaime Crespo Rincón
2011/2/22 Adarsh Sharma : > 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:

Re: [GENERAL] Mysql to Postgresql

2011-02-22 Thread Jaiswal Dhaval Sudhirkumar
Take a look at the Navicat for PostgreSQL. -- Thanks & Regards Dhaval Jaiswal Cell: +91 80953.978.43 From: pgsql-general-ow...@postgresql.org on behalf of Adarsh Sharma Sent: Tue 2/22/2011 2:51 PM To: pgsql-general@postgresql.org Cc: my...@lists.mysql.com Sub

Re: [GENERAL] Mysql to Postgresql

2011-02-22 Thread Jens Wilke
On Tuesday 22 February 2011 10:21:01 Adarsh Sharma wrote: Hi, > Today I need to back up a mysql database and restore in Postgresql > database but I don't know how to achieve this accurately. > > Can anyone kindly describe me the way to do this. Have a look here: http://wiki.postgresql.org/wik

Re: [GENERAL] MySQL to Postgresql schema conversion

2008-09-30 Thread Chris
Sean Davis wrote: There are a number of mysql to postgresql converters available, but many of them have significant shortcomings. Has anyone found a tool that works well? I am trying to convert a couple of relatively large, public schema to postgresql. I couldn't find anything either but ende

Re: [GENERAL] MySQL to Postgresql schema conversion

2008-09-30 Thread Sean Davis
On Tue, Sep 30, 2008 at 1:18 PM, Merlin Moncure <[EMAIL PROTECTED]> wrote: > On Tue, Sep 30, 2008 at 12:48 PM, Sean Davis <[EMAIL PROTECTED]> wrote: >> On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <[EMAIL PROTECTED]> wrote: >>> There are a number of mysql to postgresql converters available, but >>>

Re: [GENERAL] MySQL to Postgresql schema conversion

2008-09-30 Thread Merlin Moncure
On Tue, Sep 30, 2008 at 12:48 PM, Sean Davis <[EMAIL PROTECTED]> wrote: > On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <[EMAIL PROTECTED]> wrote: >> There are a number of mysql to postgresql converters available, but >> many of them have significant shortcomings. Has anyone found a tool >> that wo

Re: [GENERAL] MySQL to Postgresql schema conversion

2008-09-30 Thread Sean Davis
On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <[EMAIL PROTECTED]> wrote: > There are a number of mysql to postgresql converters available, but > many of them have significant shortcomings. Has anyone found a tool > that works well? I am trying to convert a couple of relatively large, > public sche

Re: [GENERAL] MySQL to Postgresql schema conversion

2008-09-30 Thread Merlin Moncure
On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <[EMAIL PROTECTED]> wrote: > There are a number of mysql to postgresql converters available, but > many of them have significant shortcomings. Has anyone found a tool > that works well? I am trying to convert a couple of relatively large, > public sche

Re: [GENERAL] Mysql to Postgresql

2004-06-01 Thread Richard Huxton
Richard Huxton wrote: On Thursday 12 February 2004 20:25, Prashanthi Muthyala wrote: Hi Richard Hi Prashanthi - nice to hear from you again. I've taken the liberty of cc-ing the general list on this, since there may be others who can help here. Um - 12th Feb? Where has this been lurking, and why

Re: [GENERAL] MySQL-to-PostgreSQL

2003-09-25 Thread Marek Lewczuk
I suggest you to do it manualy I'm mean the structure only... Then you can make mysqldump only with inserts... Belive me that this is much faster > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Yevgeny Ioffe > Sent: Thursday, September 25, 2

Re: [GENERAL] MySQL-to-PostgreSQL

2003-09-25 Thread Martin Marques
This scripts don't do the job completly, but give you a boost. I normally pass my MySQL dumps throught these scripts and then open them with my editor and do the changes that were missing. You will always have to make changes in things like MySQLs inconsistencys (dates that don't exist, an so o

Re: [GENERAL] MySQL-to-PostgreSQL

2003-09-25 Thread Bruce Momjian
Have you tried src/contrib/mysql scripts? --- Yevgeny Ioffe wrote: > Hello, > > I am working on transferring MySQL dumps to > PostgreSQL. I have tried the scripts I found in > relevant section of PostgreSQL documentation we

Re: [GENERAL] MySQL to PostgreSQL

2000-12-29 Thread The Hermit Hacker
http://www.pgsql.com/ -> Download On Tue, 26 Dec 2000, Nelio Alves Pereira Filho wrote: > Hi there. > > I am looking for a mysql to postgresql converter but the only I got > didn't work fine (I found this one at freshmeat). > > Does anyone knows a stable converter? > > Thanks > >