Re: [GENERAL] MySQL -> Postgres migration tools?

2010-01-23 Thread Devrim GÜNDÜZ
On Fri, 2010-01-22 at 11:15 -0800, Erik Jones wrote: > Does anyone know of any good, current migration tools out there? There is an open source tool developed by EnterpriseDB: MigrationWizard http://www.enterprisedb.com/openDownloads.do?productId=407&redirectReason=true&productVersion=otherDownl

Re: [GENERAL] MySQL -> Postgres migration tools?

2010-01-23 Thread Grzegorz Jaśkiewicz
2010/1/23 Craig Ringer : > > An InnoDB `AUTO_INCREMENT' column under MySQL 5.x is pretty similar to a > sequence. > > I increasingly think it's pretty safe to just >  's/AUTO_INCREMENT/SERIAL/g' > in DDL. Apps that use MyISAM aren't going to be fussy about how it works, > and apps that use InnoDB g

Re: [GENERAL] MySQL -> Postgres migration tools?

2010-01-23 Thread Craig Ringer
On 23/01/2010 3:31 PM, Grzegorz Jaśkiewicz wrote: On Fri, Jan 22, 2010 at 7:15 PM, Erik Jones wrote: Hello, Given that the EU has approved Oracle's acquisition of Sun w/ MySQL it's fairly likely that there may be a number of people and companies looking to move from MySQL to Postgres in the

Re: [GENERAL] MySQL -> Postgres migration tools?

2010-01-22 Thread Grzegorz Jaśkiewicz
On Fri, Jan 22, 2010 at 7:15 PM, Erik Jones wrote: > Hello, > > Given that the EU has approved Oracle's acquisition of Sun w/ MySQL it's > fairly likely that there may be a number of people and companies looking to > move from MySQL to Postgres in the coming months.  Does anyone know of any > g

Re: [GENERAL] MySQL -> Postgres migration tools?

2010-01-22 Thread Serge Fonville
Hi, I googled for 'migrate mysql to postgresql' the first 5 results seem very useful. The most useful link I found was http://www.raditha.com/mysql/mysql2pgsql.php HTH Regards, Serge Fonville On Fri, Jan 22, 2010 at 8:15 PM, Erik Jones wrote: > Hello, > > Given that the EU has approved Oracle

[GENERAL] MySQL -> Postgres migration tools?

2010-01-22 Thread Erik Jones
Hello, Given that the EU has approved Oracle's acquisition of Sun w/ MySQL it's fairly likely that there may be a number of people and companies looking to move from MySQL to Postgres in the coming months. Does anyone know of any good, current migration tools out there? A search for mysql on