Connecting Firebird db and SQL Server

Question

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?

Possible duplicate of Transfer data from SQL Server to Firebird using SSIS — Dai
– Dai, Commented Mar 3, 2019 at 23:12

Dai · Accepted Answer · 2019-03-03 23:13:07Z

1

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

answered Mar 3, 2019 at 23:13

Dai

158k31 gold badges314 silver badges436 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connecting Firebird db and SQL Server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related