Subject Re: [firebird-support] Importing data from SQL Server (null values issue)
Author Alexandre Benson Smith
Avi Schwartz wrote:

>I need to import data from SQL Server 7.0 into a new FB 1.5.1 database.
> At this time the tables on both databases will be pretty much the
>same for now. In reading Helen's book, I understood that the only way
>to import the data into FB is by using fixed-size external files which
>will be used as tables and then selected into the real FB tables. I can
>use bcp and format files to get the fixed length data files (although it
>is a real pain to create the format files for all tables), but how do I
>handle null values? What value in the external files will be recognized
>by FB to be a null value vs. a blank string?
>Is there a better way to get the data moved?

Use a Data Pump Utility, search for IBDataPump..

See you !


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil