[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 11:38 AM, Martin Kutschker wrote:

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

To much MySQL specific SQL in the dump...

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


Currently I connect to both databases at the same time,
extracting table by table and load the data back in.

But adding a option to dump a MySQL
database into a file that is supported by PostgreSQL is easy.

Ries