Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: storing byte values
On 8 Aug., 12:28, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> Did you take a look at the Migration Workbench?!?
I did today... Nice tool indeed!
Unfortunately it seems to support only DB2/400 version V4R3 and V4R5.
We have V5R4. But I tried it with an MS SQL-Server 2005 database which
has been migrated from the DB2 before.
Anyway, the migration needs to be done from within our application with JDBC, but I can use the Migration Workbench for some tests and experiments.
As Vladimir pointed out in a previous post, the RAW type does NOT have the one-column-per-table restriction. I got confused with LONG RAW. So I can use RAW for the key fields and BLOB for larger fields that are not used as a key. This means that our migration has a restriction of binary keys with maximum 2000 bytes. I think we can live with that for some time. Received on Wed Aug 08 2007 - 11:06:54 CDT