Subject | fbcopy - can I get "update or insert ..." |
---|---|
Author | Nick Upson |
Post date | 2009-08-07T12:18:05Z |
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]
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]