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

    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
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Have a look at Maaher's walkthrough on OraFAQ forum; although it ends up with Forms (step 8) (which you don't need), everything else *should* help (at least, I hope so).

Posting Permissions

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