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

[Martin Kutschker]

ries van Twisk schrieb:
> 
> 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.

Oh my. What failed?

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

I think that a dump file, perhaps created by a PHP script, is easier to 
handle as I can install the result whithout need to have access to both DBs 
  simoultanesly.

Masi