Re: Migrating DAta from MSSQL to postgre

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Migrating DAta from MSSQL to postgre
Date: 2002-11-26 06:45:01
Message-ID: 3DE365C5.3202.32E4251@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 26 Nov 2002 at 10:53, Savita wrote:

> Hi All,
>
> I need some help to migrate data from MSSQL to Postgres.
>
> I have the following a scnirio like.
>
> 1.I have a table in MSSQL.
> 2.I have another table in Postgres with different name and schema from the one
> which is present in MSSQL.
>
> Is it possible to migrate data from the table which is present in MSSQL to
> Postgres.

Obviously there are some commanalities between these two.. Some little scripts
in sed and awk might get you the text formatting needed for interoperation.

Text dump from one table and text load to other is the only way I can think..

HTH

Bye
Shridhar

--
Random, n.: As in number, predictable. As in memory access, unpredictable.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Savita 2002-11-26 06:54:43 Re: Migrating DAta from MSSQL to postgre
Previous Message annachau 2002-11-26 06:42:26 Re: Migrating DAta from MSSQL to postgre