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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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.

Browse pgadmin-support by date

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