> > I am attempting to recreate our Firebird database in SQL Server
> > including all data. I have contemplated using external tables to
> > export from FB and then BULK INSERT into SQL Server.. Any suggestions?
> >
> > Anyone tried this? What are the limitations? Is this the fastest
> > technique?
>
> External tables will lose all NULLs you may have in tables. It should be

the

> fastest way, but surely not the most reliable.
>
> Next fastest (which I would recommend too) is that you use some data-pump
> that knows about Firebird and MSSQL server. There is freeware Interbase
> DataPump by CleverComponents, but the last version I tried could only copy
> from MSSQL to Firebird, and not the other way. If you have a few hours you
> could write a simple PHP script to do it for you.

<plug>
The DataPump tool in Database Workbench supports MS SQL and Firebird
in both directions.
</plug>

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com