Hi all,

I have a file in Fire bird Database (30 GB with .ydb extension).  which needs to be restored to SQL Server. I Have created a linked server and done it but it is taking very long time to update the records. Can any one please suggest if u have any alternate method to do this.

Thanks in Advance

Regards,

Balaji Prasad B

Can you post the query you are using to perform select/ update from Firebird database?

I suggest you use: OPENQUERY or OPENDATASOURCE instead of 4-Part Linked server query, this is to make direct call to Firebird and this will be efficient

Let me know