[TYPO3-dev] PostgreSQL native drive for TYPO3 status update... and question about : 102: These fields are not properly

[ries van Twisk]

On Oct 2, 2007, at 10:49 AM, Martin Kutschker wrote:

> ries van Twisk schrieb:
>> hey martin and Moreno,
>>
>> what I will do is for this tool keep multi-RDBM migration in my mind.
>> Unfortunately currently it needs an MySQL installation
>> to copy a running installation to PostgreSQL.
>
> I think that the migration tool is nice but not a must have as long  
> as the
> installer can create a clean DB from scratch. If then everything  
> runs fine
> (no SQL errors or weird behaviour) the converter is of interest,  
> though I
> think no live copying is needed. Why not dump Mysql with one of the  
> (not so
> new) compatibiliyt switches?
>
> Masi
> _______________________________________________


hey Masi,

I tried that and according to the documentation this should work:

mysqldump -uroot --compatible=postgresql pgtest > pgtest.sql

But the resulting SQL file is far from PostgreSQL compatible.

Writing a couple of functions to transfer data from MySQL to PostgreSQL
was for this exercise far faster then trying to use one of teh  
conversion scripts.
I just needed to get Data in PostgreSQL the fast way.

Agreed it's not a must... However since all SQL are MySQL compatible,
it is now very easy to generate a PG version with a click of a button...

Ries