> :: Have you czeched out Database Workbench? It has a good data pump.
>
> Can it be automated? :)

Database Workbench includes two tools to make this task possible,
but it cannot be automated. Currently, it's a GUI driven task that
allows you to convert your schema (datatypes, domains, tables,
views, indices, constraints) from Firebird to MS SQL Server, the
other way around etc...

It also has a DataPump to transfer your data.

For quick info, you might want to check:
http://www.upscene.com/documentation/dbw/tools_schemamigrator.htm

There will be a new version real soon now, that includes several
bugfixes in this tool as well.

With regards,

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