Subject Re: Importing data from SQL Server (null values issue)
Author dirknaudts
Or you can use IBExpert, together with the Interbase DataPump from
Clevercomponents, which works fine for me :-)


Dirk Naudts
ATS Belgium.

--- In, Milan Babuskov <milanb@k...>
> Avi Schwartz wrote:
> > I need to import data from SQL Server 7.0 into a new FB 1.5.1
> > At this time the tables on both databases will be pretty much
> > 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
> > 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
> > by FB to be a null value vs. a blank string?
> >
> > Is there a better way to get the data moved?
> After reading all the posts I have a suggestion for you. Since you
> on Unix-based system, the best option (IMHO) would be to use PHP.
It has
> direct bindings for MSSQL and Firebird. Just write a simple script
> will query one db and insert data into other. A hour of work tops.
> --
> Milan Babuskov