| From: | "Miguel Juteau" <miguel(at)yellowasp(dot)com> |
|---|---|
| To: | <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Migration from Oracle |
| Date: | 2002-04-12 03:00:32 |
| Message-ID: | BHEBJAOLIDOKDBMPAKBNGEILCDAA.miguel@yellowasp.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Hello,
I can't make the migration wizard work. I'm trying to migrate an Oracle
database from a network server, to Postgres.
I installed the Oracle client on my Windows client box, and can connect
successfully to the Oracle server. I created a system odbc data source on my
box, a system DSN, using the Oracle ODBC driver.
When I try to migrate with the pgadmin wizard, I am able to connect to the
Oracle database as an ODBC source. I select to migrate all tables and all
data.
Then I get this warning: 'foreign keys are not supported with this provider.
When the migration starts ( "Creating table CUSTOMER" ), it fails right
away, with this error message:
-2147217887: ODBC driver does not support the requested properties.
What should I do? Please help me, I'm almost there! :)
Miguel Juteau
Yellowasp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2002-04-12 08:40:26 | Re: Migration from Oracle |
| Previous Message | Dave Page | 2002-04-11 19:29:55 | Re: migration problem |