goshen couture wrote:

> I want to do two -way process consolidating data from firebird databases
> to one mssql2005 database and then from mssql2005 transfer back data to
> firebird databases. How to do and which tool to use ? Please advise.

I am not aware of any tools that do it automatically. You could set up
an external database in SQL Server using the Firebird ODBC driver and
use stored procedures, or you might just have to write something custom.

There may be tools, though. My guess is what you want is some kind of
cross-database replication server. I would use keywords like
"replication cross database" in google to look.

Dean.