Firebird to SQL Server Migration.

Question

1. Is there a tool native to SQL Server to do the migration (i.e., Import/Export)?

2. Any other options (SSIS).

Please point me to helpful info.

Answer 1

SQL server comes with import / export functionality. I don't know much about Firebird, but if it support ODBC, you can install the ODBC driver onto your SQL server, and import away.

Answer 2

you could write a quick app that dumps all your data as XML from Firebird. Your SSIS can take it from there. Considering you dont have huge amouts of data, for which Firebird is ideal

Answer 3

here is the guide http://forums.devshed.com/firebird-sql-development-61/export-firebird-db-568805.html

also there is fbexport to export to xml/csv forma http://fbexport.sourceforge.net/ http://firebirdsql.org/dotnetfirebird/blog/2005/01/fbexport-command-line-tool-for-data.html

ps: maybe i should add an json option :) for it