Subject Re: fbcopy - can I get "update or insert ..."
Author Muthu Annamalai
--- In firebird-tools@yahoogroups.com, Nick Upson <nick.upson@...> wrote:
>
> I'm trying to use fbcopy to handle an upgrade, where I install a new
> database and move the data from the old to the new.
> the problem I have is that for some tables I need to insert where the data
> does not already exist and update where it does exist (based on PK)
>
> does such a method already exist ? if not suggestion on how to achieve it
> are very welcome.
>
> (This has to run from the unix command-line so gui tools or windows only
> tools are no help)
>
>
> [Non-text portions of this message have been removed]
>

I am also into similar situation, where i constantly make changes to database and i have to get my customer database and update it manually using ibpump ( Windows ), if there is automated way to do this, it will be very helpful. Please help me if you have any good solution to deal with