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

Oracle->Postgres Migration Problems.

From: David Griffiths <dgriffiths(at)boats(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Oracle->Postgres Migration Problems.
Date: 2002-04-15 21:33:26
Message-ID: 01b601c1e4c5$308afd70$8701a8c0@griffiths (view raw or flat)
Thread:
Lists: pgadmin-support
I am trying to use the migration plugin to migrate my tables and data from
Orace 8i to Postgres 7.2 on Redhat 7.2

I'm doing a small test to see how well it works, but I'm not getting very
far. I have Oracle installed, and have a System DSN setup. If I pick a
standard table (varchars, numbers, dates) and do the conversion, I get:

An error occured at: 15/4/2002 2:24:42 PM:
9: Subscript out of range

Rolling back... Done.

I read through the mailing archive, and noticed that Dave had asked that
debugging turned on and the contents of the log window sent, so that's what
I've done (nothing else in there that I could find). I've just subscribed to
the mailing list, but I've looked to make sure I wasn't posting a topic that
had been answered earlier; but if I've missed it, I apologize.

The logs are below (note that I asked for lower-case conversion of all
tables, indexes, etc). I x'd out any connection info for security reasons.

BTW, a great tool, aside from this little glitch.

David


15/4/2002 2:24:41 PM - Entering pgSchema:pgServer.ExecSQL("BEGIN",
"Connection: Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=xxx;SERVER=192.168.12.137;PORT=5
432;UID=postgres;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0
;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKN
OWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=1;COMMLOG=1;OPT
IMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=
1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_"")
15/4/2002 2:24:41 PM - SQL (xxxx): BEGIN
15/4/2002 2:24:41 PM - Creating table: BOATS
15/4/2002 2:24:41 PM - Entering Database Migration
Wizard:frmWizard.txtStatus_Change()
15/4/2002 2:24:42 PM - Entering Database Migration
Wizard:frmWizard.txtStatus_Change()
15/4/2002 2:24:42 PM - Entering pgSchema:pgServer.Property Get Databases()
15/4/2002 2:24:42 PM - Entering pgSchema:Databases.Property Get
Item("xxxx")
15/4/2002 2:24:42 PM - Entering pgSchema:pgDatabase.Execute("ROLLBACK",
0, -1)
15/4/2002 2:24:42 PM - Entering pgSchema:pgDatabase.dbConnect()
15/4/2002 2:24:42 PM - Entering pgSchema:pgServer.ExecSQL("ROLLBACK",
"Connection: Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=xxxx;SERVER=192.168.12.137;PORT=5
432;UID=postgres;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0
;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKN
OWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=1;COMMLOG=1;OPT
IMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=
1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_"")
15/4/2002 2:24:42 PM - SQL (xxxx): ROLLBACK
15/4/2002 2:24:42 PM - Entering Database Migration
Wizard:frmWizard.txtStatus_Change()
15/4/2002 2:24:42 PM - Done - 1.54 Secs.


pgadmin-support by date

Next:From: Dave PageDate: 2002-04-15 22:06:13
Subject: Re: is it possible to migrate from access to ora
Previous:From: Venkatraman VishwanathamDate: 2002-04-15 20:31:22
Subject: is it possible to migrate from access to oracle?

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