Forum Discussion

daddi645's avatar
daddi645
Copper Contributor
Aug 04, 2021

Firebird to SQL Server

Hey Guys, please how can i import data from firebird to SQL server?

Thanks.

  • olafhelper's avatar
    olafhelper
    Aug 05, 2021

    daddi645 , there are several ways possible.

    Is it a one-time job or are you goto to import data several times?

    One-time job: SSMS Import/Export Wizard

    Otherwise:

    - SSIS (SQL Server Integration Services) package

    - Linked server pointing to the Firebird server/database, then you can copy data with plain T-SQL

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Aug 05, 2021

    daddi645 , there are several ways possible.

    Is it a one-time job or are you goto to import data several times?

    One-time job: SSMS Import/Export Wizard

    Otherwise:

    - SSIS (SQL Server Integration Services) package

    - Linked server pointing to the Firebird server/database, then you can copy data with plain T-SQL

Resources