Joined: 3 Mar 2012 22:17:23
I have been asked to port a number of Oracle databases to Postgres and have started working with the EnterpriseDB Migration Toolkit. Things are generally fine but, with the latest release downloaded with Postgres 9.1 I get two specific errors. I would be happy to look at them (as I think they will be pretty simple) but I can't seem to find the source for the Migration Toolkit or a issue tracker.
I have an Oracle column defined as:
IGNORE_HOLIDAYS NUMERIC(1) DEFAULT 0 NOT NULL
When I migrate this the default value does not get converted so the migration script fails:
IGNORE_HOLIDAYS BOOLEAN DEFAULT 0 NOT NULL
The second problem is more akward (I can obviously change the script manually for the above error). I try and run a data import via the tool and the SQL insert statements created are incorrect. This occurs only when I have a Blob AND a Boolean field in the table in question. So for example I have the following two columns on my Oracle table:
LIVE NUMERIC(1) NOT NULL,
And these will be converted to
LIVE BOOLEAN NOT NULL,
The problem then occurs during the creation of the insert statements. Looking at the logs these are created as follows:
... '<stream of 18111 bytes>', 1, ...
The problem is the number 1 is used instead of TRUE.
The insert SQL is created correctly for tables where there is a BOOLEAN field but not when there is a BOOLEAN field and a BLOB/BYTEA field.