m24paul wrote:

> i need a little help.
> I have 2 database A and B, and same table in both databases.
> Table X (field: Id, numeric and Desc: Blob)
>
> I need to copy blob information from A.X table to B.X table.
> This procces is a sinchronisation thing.

You can use FBExport or FBCopy, whichever suits you better. FBCopy is better
if you have multiple tables to copy. FBExport is better is you don't have
direct connection between databases. Basically, FBCopy is meant for online use
and FBExport for offline. More info here:

http://fbexport.sourceforge.net
http://fbexport.sourceforge.net/fbcopy.html

Examples:
1. FBExport usage:

fbexport -s -v X -f temp.fbx -d /path/to/source.fdb
fbexport -i -v X -f temp.fbx -d /path/to/destination.fdb

2. FBCopy usage:

Create a file (let's name it 1.def), and put this line in it:
X:Id,Desc

Run FBCopy:

fbcopy c source.fdb dest.fdb < 1.def

This is just a simple example, you can handle updates, partial exports (via
WHERE clause), etc. Both are command-line tools, so you can put them in scripts.

HTH
--
Milan Babuskov
http://www.flamerobin.org