How to link data from Firebird database to SQL Server database?

I use SQL Server quite often as part of my job to create reporting data. The new client has data in both SQL Server database and Firebird. I've never interacted with Firebird, so this may seem like a pretty straightforward question, but what would be the best way to link data between the two systems? I will need to create a small datamart to bind the data eventually as the final target.

I know the client has a Database Workbench installed for the Firebird client side and I believe this will allow me to use SQL Server syntax for FB databases, but it will allow me to bind data between them and create new views in the SQL Server database with her? Obviously, I know I can create a linked server in SQL Server Management Studio, but I had anecdotal advice that it can be potentially tricky to configure, and if there is an easier way, I'd rather go that way.

+3


source to share





All Articles