Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2013
    Posts
    3

    Unanswered: need help linking SQL server and oracle databases

    I have a some SQL and Oracle databases that I need to be able to join and query across. I need a tool that will facilitate this easily and preferably free. For example database 1 has multiple sql 2008 tables but I want Cust_info table and the field meter and then in the oracle database I need the meteraccts table and the meternumber field...which are the joiner fields. I am having trouble find something that will do this easily...I have down loaded..dbvisualizer, anysqlmaestro, oracle developer..etc These will let me see the different databases but not query both...or at least I can't see how. Any help with a tool or with a sql syntax would be appreciated. I have tried to link the databases and join them but I'm missing something. Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Microsoft provides Linked Server functionality as part of the base product, but I recommend that you install the Oracle Client onto the SQL Server to use it. Oracle allows you to buy a comparable feature called Heterogeneous Services.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Oct 2013
    Location
    Poland / USA
    Posts
    5

    Oracle Client

    install the Oracle Client and use SSIS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •