Hi,

I need to copy/move some Unicode data (mot much) from SQL Server 2005 to
Firebird 2.1 (latest version).

In older SQL Server versions the import/export wizard supported ODBC so
I could use that to copy the data into Firebird using the Firebird ODBC
driver.

But SQL Server 2005 export/import wizard only supports OLE DB, and I
can't find a free OLE DB provider for Firebird.

I tried dumping the data to a flat file instead, with the intention to
import it into Firebird using an external table. If I save the file as
ANSI, it works in Firebird, but I do need Unicode, because there are
Cyrillic letters in there and other non-ANSI stuff as well.

But how can I get Firebird to import a Unicode text file? I can save it
as Windows "native" Unicode which is, I believe UTF-16 little endian, or
I can save as UTF-8 or UTF-16 big endian.

Any other options I should try for getting the data copied?

Thanks,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64