Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: Migrating DAta from MSSQL to postgre

Re: Migrating DAta from MSSQL to postgre

From
"annachau"
Date:
I use pgADMIN II to import MSSQL to postgre

-----Original message-----
From:Savita <savita@india.hp.com>
To:Pgsql-General <pgsql-general@postgresql.org>
Date:Tue, 26 Nov 2002 10:53:34 +0530
Subject:[GENERAL] Migrating DAta from MSSQL to postgre

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.
-
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: Migrating DAta from MSSQL to postgre

From
Savita
Date:
Hi annachau,

Thanks for the reply.I also tried PGADMIN II ,but I was geeting some errors using
that.Also I would like to know something about pgadminII.

1.Should we have same table existing in MSSQL and postgre if we use PGADMIN II.


annachau wrote:

> I use pgADMIN II to import MSSQL to postgre
>
> -----Original message-----
> From:Savita <savita@india.hp.com>
> To:Pgsql-General <pgsql-general@postgresql.org>
> Date:Tue, 26 Nov 2002 10:53:34 +0530
> Subject:[GENERAL] Migrating DAta from MSSQL to postgre
>
> 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.
> -
> Best Regards
> - Savita
> ----------------------------------------------------
> Hewlett Packard (India)
> +91 80 2051288 (Phone)
> 847 1288 (HP Telnet)
> ----------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------

Re: Migrating DAta from MSSQL to postgre

From
Mike Mascari
Date:
Savita wrote:
> Hi annachau,
>
> Thanks for the reply.I also tried PGADMIN II ,but I was geeting some errors using
> that.Also I would like to know something about pgadminII.
>
> 1.Should we have same table existing in MSSQL and postgre if we use PGADMIN II.
>
>
> annachau wrote:
>
>>I use pgADMIN II to import MSSQL to postgre

Short form: Postgres
                    ^
Long form: PostgreSQL

Mike Mascari
mascarm@mascari.com

Re: Migrating DAta from MSSQL to postgre

From
Jeff Eckermann
Date:
PgAdmin II will create the table for you.
If you want the table structure to be different, you
could always create a new table with the structure you
want, then insert the data from the migrated table.
If you get errors with PgAdmin II that you cannot
resolve, post details to the pgsql-interfaces list,
and someone there can probably help you.

--- Savita <savita@india.hp.com> wrote:
> Hi annachau,
>
> Thanks for the reply.I also tried PGADMIN II ,but I
> was geeting some errors using
> that.Also I would like to know something about
> pgadminII.
>
> 1.Should we have same table existing in MSSQL and
> postgre if we use PGADMIN II.
>
>
> annachau wrote:
>
> > I use pgADMIN II to import MSSQL to postgre
> >
> > -----Original message-----
> > From:Savita <savita@india.hp.com>
> > To:Pgsql-General <pgsql-general@postgresql.org>
> > Date:Tue, 26 Nov 2002 10:53:34 +0530
> > Subject:[GENERAL] Migrating DAta from MSSQL to
> postgre
> >
> > 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.
> > -
> > Best Regards
> > - Savita
> >
> ----------------------------------------------------
> > Hewlett Packard (India)
> > +91 80 2051288 (Phone)
> > 847 1288 (HP Telnet)
> >
> ----------------------------------------------------
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
> --
> Best Regards
> - Savita
> ----------------------------------------------------
> Hewlett Packard (India)
> +91 80 2051288 (Phone)
> 847 1288 (HP Telnet)
> ----------------------------------------------------
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to majordomo@postgresql.org
> so that your
> message can get through to the mailing list cleanly


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com