[pgadmin-support] migration tool

[Miguel Juteau]

Hello,
I tried to use the migration plug-in to migrate from Oracle to Postgres, but
I failed to connect to the Oracle database. This db is on a server, so
normally I use an IP address to connect to it. In the migration tool, I set
the db type to 'SQL server database'. But then there are only a 'Server
Name' and a 'Database Name' fields. How can I connect to my remote server? I
tried Server Name = [EMAIL PROTECTED] but that didn't work.
What did I miss?

Miguel Juteau




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

[pgadmin-support] Migration from Oracle

[Miguel Juteau]

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



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org