Subject Importing data from SQL Server (null values issue)
Author Avi Schwartz

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?