Обсуждение: migration tool

Поиск
Список
Период
Сортировка

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 = myServerName@192.0.32.254 but that didn't work.
What did I miss?

Miguel Juteau




Re: migration tool

От
Dave Page
Дата:

> -----Original Message-----
> From: Miguel Juteau [mailto:miguel@yellowasp.com]
> Sent: 09 April 2002 06:20
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] migration tool
>
>
>
> 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 =
> myServerName@192.0.32.254 but that didn't work. What did I miss?

The SQL Server option is for Microsoft SQL Server. If you setup an ODBC
datasource (using the ODBC driver manager in Control Panel) to point to your
database, you can then use the ODBC migration option.

Regards, Dave.