Subject Re: [firebird-support] Migrate from Firebird to MSSQL2005
Author Milan Babuskov
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:

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:


in both directions.

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