Subject Re: [firebird-support] Firebird and mssql2005
Author Milan Babuskov
goshen couture wrote:
> I want to do synchronization or transfer of data from Firebird 2.0(contain chinese character using unicode_fss) to MSSQL2005 and from MSSQL2005 back to Firebird 2.0.(contain chinese character using unicode_fss). How to do it ? Please advise.

The easiest way is to use Firebird's ODBC driver and register the
Firebird database as external data source in MSSQL. After that you can
do simple INSERT/UPDATE/DELETE statements like:

insert into mssql.table1
select * from firebird.table1;

from MSSQL Enterprise Manager (or whatever it is called these days).

Milan Babuskov