CODEWITHSUNDEEP
sql-serverfirebird
Djokovic
Djokovic

Reputation: 9

Connecting Firebird db and SQL Server

I would like to connect Firebird db to my SQL Server database. Purpose of this is that I want the SQL Server database refreshed with Firebird data every night, so obviously make a job.

I looked around and saw a lot of tools and drivers that you need to get in order for this to work, and when I looked at them, they are ether a work in progress or a scam.

Does anyone have any ideas how to do this reliably?

Upvotes: 1

Views: 2901

Answers (1)

Dai
Dai

Reputation: 154995

Use SQL Server Integration Services (SSIS) that runs a job in SQL Agent. SSIS supports any OLE-DB or ODBC data source, just set your SQL Server instance as the destination.

Here's an example using Firebird, SSIS and InterBase - but you can skip the parts for InterBase: https://www.ibprovider.com/eng/documentation/ssis_firebird_interbase.html

Upvotes: 1

Related Questions