Skip site navigation (1) Skip section navigation (2)

Re: migration tool

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: 'Miguel Juteau' <miguel(at)yellowasp(dot)com>,pgadmin-support(at)postgresql(dot)org
Subject: Re: migration tool
Date: 2002-04-09 07:10:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support

> -----Original Message-----
> From: Miguel Juteau [mailto:miguel(at)yellowasp(dot)com] 
> Sent: 09 April 2002 06:20
> To: pgadmin-support(at)postgresql(dot)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(at)192(dot)0(dot)32(dot)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.

pgadmin-support by date

Next:From: Camila RochaDate: 2002-04-09 19:44:58
Subject: data types oid and oidvector
Previous:From: Jean-Michel POUREDate: 2002-04-09 06:21:20
Subject: Re: first time

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group