Java, itself, makes a slick data pump. Make a JDBC connection to both
databases then select from one and insert into the other.

I'm getting about 6,000,000 rows per hour using this mechanism (with an
XSLT piece in the middle to transform the data from one applications
data model to the other) limited by the speed of the mainframe that
feeds the input side of the process. Using JDK 1.4.2 and xalan. It
took 2 days to write the core code (but I can't give it out due to
confidentiality stuff).

On Tue, 2005-03-29 at 19:26 +0000, Thiago Costa wrote:
>
>
> Dear friends,
>
> How can i change the charset of an existing firebird database?
> A solution that i think is create another database with another
> charset and pump the data to it. But my database has many triggers,
> procedures, index etc and the most data pumps software that i konow
> dont handle that very well. Anyone knows how to change charset or
> knows any good data pump?
>
> Thanks
>
> Thiago Costa
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>