> >Do you mean a data-transfer? You could set up a datapump project
> >with our tool, Database Workbench, and use the command-line version
> >in your own project ...
>
> Thanks a lot I have just checked it out, but frankly I was looking for a
> freeware or open source stuff.
>
> Actually I need something to convert the database to the newer version
> either by modifying the data structures by comparing with the empty
> database that is provided or like I mentioned transfer data from one to
> another. But all in all it has to be adaptive, I cannot have user
> intervention as we have ltd. knowledge support staff and (more than) at
> times have to rely on the user installing the application themselves.

Ah, so you don't want to transfer data alone, but it should also update
existing structures?

Hmmm - let me tell you, it just ain't that easy... :-)

You might want to investigate a different way of doing things:

1) keep a version number if your database

2) create an "update" application that includes scripts to update your
database
from one version to another

3) run the update app, check version number, run scripts.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com