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.

Unfortunately, fbcopy does not support this (yet). It is not a very big
task to add that feature esp. if you are using Firebird 2.1 or above
which has a single statement that does the job. However, I'm leaving on
a vacation tomorrow and I will not have computer for 2 weeks, so I
probably won't be looking into it soon ;)

However, the sources are open source and very simple, so I guess anyone
with some C++ knowlegde could add this to FBCopy easily. Provided that
you know someone with C++ skills, that is.



--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================