Thread: PGadmin db migration

Hi,

The latest .12 version is working great, allowing me to ODBC from SQl 2000
to Postgres.  I moved 900,000 records in 11 minutes.

I'm trying to copy just data to already existing tables.   Is that possible
or do I have to delete all keys and constraints first.  When I try, it
complains that sequences already exist.

Thanks,

John Bercik

It's rumoured that John Bercik once said:
> Hi,
>
> The latest .12 version is working great, allowing me to ODBC from SQl
> 2000 to Postgres.  I moved 900,000 records in 11 minutes.

Excellent! I love it when things work as they should :-)

> I'm trying to copy just data to already existing tables.   Is that
> possible or do I have to delete all keys and constraints first.  When I
> try, it complains that sequences already exist.

No it's not possible - unfortunately data-only migration is still on the
ToDo list.
Regards, Dave