Re: porting a full Ms Sql Server to postgres

pwbyrne@hotmail.com wrote:

>Hi,
>
>I'm looking for details, or tools about porting a full Ms Sql Server
>2000 database to Postgres on Linux.
>
>Is this possible?  We have the whole nine yards, stored procedures,
>triggers, and all.  
>
>Is there a way to automate this process?
>
>Thanks
>  
>
Totally automate - no.

There are tools to help you along, however. They are not as complete as 
I would like them, and I need lots of help in maintaining the site. It's 
located at http://pgfoundry.org/projects/sql2pg/, but there are 
currently no released files. In CVS, however, you will find a perl 
script that translates the exported database description from MS SQL to 
a more-or-less PG friendly format. Also you will find there support for 
two data types - varcharci (case insensitive) and utinyint (1 byte 
unsigned integer).

Any help with maintaining this project would be greatly appreciated.

I do have a few questions for you. What drivers do you currently use to 
access your database? Do you use the stored procedure's ability to 
return more than one result?

                Shachar

-- 
Shachar Shemesh
Lingnu Open Source Consulting ltd.
http://www.lingnu.com/