goshen couture wrote:

> I think i'm going to migrate from firebird database to MSSQL2005 if there is not much support for doing data transfer or synchronization from firebird(containing chinese char unicode_fss) to mssql2005 and from mssql2005 back to firebird(containing chinese char unicode_fss).

I know at least 2 good ways of doing it:

1.
You can install Firebird ODBC driver and attach it to MSSQL as 'external
data source' (or something like that, I forgot the exact name).

After that, you can do simple:

INSERT INTO ... SELECT ... FROM ...

in both directions.


2.
Install IBDataPump and MSSQL ODBC driver. Use it to copy the data. You
can't use SQL for this, so maybe there is less control - but it's fine
if you just want to copy data around.


--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com