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