Re: [GENERAL] Mysql to Postgresql

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

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

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

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/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

.com Subject: [GENERAL] Mysql to Postgresql 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. Can anyone kindly describe me the way to do this. Thanks & best Regards, Adarsh Sharma -- Sent via

Re: [GENERAL] Mysql to Postgresql

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

[GENERAL] Mysql to Postgresql

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. Can anyone kindly describe me the way to do this. Thanks & best Regards, Adarsh Sharma -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] MySQL to Postgresql schema conversion

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

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

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

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

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

[GENERAL] MySQL to Postgresql schema conversion

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. Thanks, Sean -- Sent via pgsql-general mailing list (pgsql-

[GENERAL] MySQL to PostgreSQL, was ENUM type

So, it seems to me that there is a fair bit of work to be done on helping people migrate MySQL to PostgreSQL. So far, the checklist I can see includes: * Maintaining conversion scripts * Reviewing pain points and looking at ways of mitigating them. * Building solid migration documentation *

Re: [GENERAL] Mysql to Postgresql

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

[GENERAL] Mysql to Postgresql

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. > I am trying to migrate the database and its tables from mysql in my >

Re: [GENERAL] MySQL-to-PostgreSQL

day, September 25, 2003 9:20 PM > To: [EMAIL PROTECTED] > Subject: [GENERAL] MySQL-to-PostgreSQL > > > Hello, > > I am working on transferring MySQL dumps to > PostgreSQL. I have tried the scripts I found in > relevant section of PostgreSQL documentation website, > but

Re: [GENERAL] MySQL-to-PostgreSQL

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

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

[GENERAL] MySQL-to-PostgreSQL

Hello, I am working on transferring MySQL dumps to PostgreSQL. I have tried the scripts I found in relevant section of PostgreSQL documentation website, but they all give me various parsing errors. What am I to do? Thanks! ---(end of broadcast)-

Re: [GENERAL] MySQL to PostgreSQL

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 > >