Communication between SQL & Oracle

navimbsnavimbs Member Posts: 137
edited 2008-05-09 in SQL General
Hi,

Has anybody worked on communication between Navision SQL Server & Oracle database?

Does Linked server work with SQL & Oracle to transfer data from SQL to Oracle? Can two databases talk with linked server if they stand at the same location.

I have gone through two options in documents - Linked Server & Biztalk Server

Regards,

Comments

  • krikikriki Member, Moderator Posts: 9,112
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • bbrownbbrown Member Posts: 3,268
    Biztalk Server is a definite option. The question is whether it fits your application's requirements.

    A linked server is also an option. You may face some restrictions depending on the version of your Oracle ODBC driver.
    There are no bugs - only undocumented features.
Sign In or Register to comment.