Re: MSSQL to PostgreSQL

Iv Ray wrote:
>> Hi Ray,
>>
>> I have something that does this. I am currently awaiting project
>> approval on pgfoundry.
>> It does tables, views, and stored procedures. I have tested it on
>> 450,000 lines of mssql code
>> including 400 tables and 3700 stored procedures, although it is a
>> work in progress.
>>
>> I applied last week and they said it takes 72 hours. As soon as it is
>> approved I can post it.
>> (give it a couple days I guess)
>>
>> Gwyneth
>
> Hi Gwyneth,
>
> sounds very interesting.
>
> We found this -
>
> http://wiki.postgresql.org/wiki/Converting_your_data_from_MS_SQL_Server_7_to_PostgreSQL_7.1.x
>
>
> (for very old version)
>
> - it is surprising that the SQL Enterprise Manager does this... We
> gave it a little try today and saw that indeed, there is "PostgreSQL"
> in there. But we left to try it tomorrow. Do you know it?
>
> We do not have stored procedures, only tables and views. Would be, in
> any case, interested in seeing what you have.
>
> Iv
Ray,

I think we tried that and I think it works but not for us. It may work
for you.

MS wants to copy all the tables over with exactly the same names
including [dbo]. and so on.
When it doesn't find an exact match, it wants to create the table. This
may be ok for you but
I am not sure what it does about mapping datatypes. This is controlled
in my program by precreating the
tables with the desired mappings. (we have mostly found what works but
it can be changed easily)

We have over 400 tables and as they are related, they need to be loaded
in a particular order.
I control this with a file of table names (dropped out of the conversion
program)

The data copy is only a few scripts largely based on FreeTDS. (do a
google, I won't post a link here)

So give the Enterprise Manager a try. It may work for you. I think we
only had to install a Postgres odbc driver.

My program(s) should be available soon (few days I figure) when I get a
place to post it.

Gwyneth