Oracle->Postgres Migration Problems. - Mailing list pgadmin-support

From David Griffiths
Subject Oracle->Postgres Migration Problems.
Date
Msg-id 01b601c1e4c5$308afd70$8701a8c0@griffiths
Whole thread Raw
List 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:

Previous
From: Dave Page
Date:
Subject: Re: is it possible to migrate from access to ora
Next
From: Dave Page
Date:
Subject: Re: Oracle->Postgres Migration Problems.