Re: Import Data from MS SQL Server

On 7 Jun 2006 05:13:15 -0700, Daniel <DFelix19(at)gmail(dot)com> wrote:
>
> Hi..
> Im Daniel and need soem help in importing data from MS SQL Server
> to Postgresql DB. Is there a bulit in option for importing from
> Postgresql? Help me out!!

as others suggest, you definately want to go 'dts' on anything to/from
ms sql server. dts can actually transfer from any odbc to any other
odbc source. you could for example do a dts transformation from ms
sql to csv files and then do csv import into postgresql via the copy
command. you would still want to use dts to create the tables though.
one tip: take the opportunity during the conversion process to
convert your tables to all lower case and no spaces in the
table/column names.

Merlin