Hi Milan,

i use ibpump for manual data transfer but i need auto and programmable data transfer tool.

I have used data transformation service in mssql2000 to do data transfer but in mssql2005 i cant find the dts what method should i use ? another issue is how to transfer chinese char unicode_fss from firebird to mssql2005 and from mssql2005 back to firebird ? please advise thanks

regards
halim S

Milan Babuskov <milanb@...> wrote: 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






---------------------------------
Yahoo! Toolbar is now powered with Search Assist. Download it now! /a

[Non-text portions of this message have been removed]