Re: Connecting to Oracle Guru needed

Since you have SQL Server, you also have the ability to import data from virtually any data source--including Oracle.
I would use TSQL BulkCopy, SSIS or the SqlClient.SqlBulkCopy classes to import the Oracle data (periodically) into a SQL Server table and use it there. Another approach (if the Oracle data is constantly changing) is to create a "linked" server, but this more difficult. Once created, the linked server database (and tabled) can be selected like any local table.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________



"TheNovice" <TheNovice@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BFA28833-5587-4668-A5C3-369527A8B928@xxxxxxxxxxxxxxxx
good day all,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
And if this is the wrong message borad please let me know where the best
place to find this info.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I have a question and need help (lots of it) with. I have a DB in our SQL
server that with a "VIEW" (or please recommend another option) I need to
connect to Oracle and extract information for a information board. I can get
access to all of our other DB's but Oracle seems to be the most difficult.

Can anyone guide me to the most effective way, using a "View" so that I can
create/update our tables with info that is going to go to our lightboards...



--
-The Novice
Learn Today, Teach Tomorrow

Great Success is ones ability to ask for Help.

.

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)
  • Re: command line vs grid control
    ... have Oracle on-site for their line-of-business applications. ... customers that Oracle(all of its products not just the RDBMS) run on ... SQL Server where appropriate. ... Written any shell scripts in Windows to ...
    (comp.databases.oracle.server)
Loading