Ad

How To Convert Legacy Interbase DB To SQL Server?

- 1 answer

I have an Interbase DB. How can I convert it to SQL Server?

Ad

Answer

You could use SQL Server built in Data Transformation Services (DTS) in SQL Server 2000 or SQL Server Integration Services (SSIS) in SQL Server 2005.

Try setting up an ODBC DSN for Interbase. Then in DTS / SSIS use the Other (ODBC Data Source) and the DSN.

If that does not work then see if Interbase has a utility to export to text files and then use DTS / SSIS to import the text files.

Ad
source: stackoverflow.com
Ad