using dataport

From: Tore Halset (halse..vv.ntnu.no)
Date: Fri Jan 09 2004 - 07:42:22 EST

Next message: Andrus Adamchik: "[FIXED] Re: Strange Null Pointer"

Previous message: Andrus Adamchik: "Re: Using Multiple Domain in a Web Application"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello!

I am using dataport to move data from MS SQL Server to PostgreSQL and
it realy is the perfect tool!

The small problems that I got around:
1. The database has two tables that has blob columns. A single blob are
not larger than 5MB, but the tables can have ~5k rows. This lead to a
java.lang.OutOfMemoryError, but giving java more memory helps a lot
% ANT_OPTS="-Xmx512M" ant

2. I used to have one table with a recursive relationship. Each
MENU_ITEM could have several sub-items. This lead to a error:
Error porting data: ERROR: insert or update on table "menu_item"
violates foreign key constraint "$2"
Removing the relationship in the model (and in the destination
database) solved the problem.

dataport is realy useful for me.

Regards,
- Tore.

Next message: Andrus Adamchik: "[FIXED] Re: Strange Null Pointer"
Previous message: Andrus Adamchik: "Re: Using Multiple Domain in a Web Application"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Fri Jan 09 2004 - 07:42:41 EST