Working with Oracle

• Topics

  Started by

  Posts

  Last post

• is it possible to have Single instance(name or SID) on multiple database?

  Hi Folks, I wanted to know that can we have a single instance on two different databases? I am till…

  nikunj_lodhi

  6 replies

  11 years, 4 months ago

  By: PaulB-TheOneAndOnly

• Oracle 32 bit client on 64 SQL Server 2008

  Specs: Windows Server 2003 R2 x64 SP2 SQL Server 2008 10.0.2531 (64 bit) Visual Studio 2008 v9.0.30…

  Dirt McStain

  12 replies

  11 years, 5 months ago

  By: 99th.in

• mysql connector ODBC 5.2 not showing

  I tried to transfer data from ms sql server 2012 to mysql using sql server export, but could not fi…

  ejikoko

  1 replies

  11 years, 5 months ago

  By: Sean Lange

• Installing Oracle 11g Client in a sql server 2008R2 active/passive Clustered Environment

  I'm trying to get a step-by-step approach to installing Oracle 11g Client in a sql server 2008r2 Ac…

  ericwenger1

  3 replies

  11 years, 6 months ago

  By: ericwenger1

• How to make a solution real-time replicate from oracle and mysql to SQL server?

  Anyone have experience like this please share, my company need to reduce licensing of oracle. thank…

  krit

  7 replies

  11 years, 6 months ago

  By: Jeff Moden

• please help me convert this part into SQL Server.

  IF OUT_PAT_VISIT_ID_V = 'Collected' and NO_OUT_PAT_VISIT_ID_V = 'Collected' THEN :NEW.PAT_VISI…

  ekant_alone

  3 replies

  11 years, 6 months ago

  By: Ed Wagner

• Compare an Oracle Database with a Sql Database !

  Hi, first of all, i'm biginner in Bi Consulting with Microsoft tools. I want to compare two databas…

  salmita

  1 replies

  11 years, 6 months ago

  By: PaulB-TheOneAndOnly

• Problem with dbms_metadata.get_ddl

  I get Data from some Oracles Database. We own the Data but the system was designed by an outside fi…

  Welsh Corgi

  2 replies

  11 years, 7 months ago

  By: Welsh Corgi

• Need better solution to Import from Oracle

  I maintain BI that needs to import the data from Oracle every day. I use the import wizard to creat…

  Sezam

  8 replies

  11 years, 7 months ago

  By: Sezam

• GROUP BY Subcase_Number within several columns

  I posted on forums.oracle a couple hours ago but haven't heard anything yet. Figured I'd try this b…

  SqlHomebrewer

  7 replies

  11 years, 7 months ago

  By: Lynn Pettis

• SQL 2008 R2 linked server to 11g

  I've been tasked with setting up an Oracle linked server on a new SQL 2008 R2 install. I have inst…

  scogeb

  9 replies

  11 years, 7 months ago

  By: John Langston

• Oracle ODBC Driver

  We are running into a issue with our development SSIS server. We have a Oracle 10g driver loaded a…

  mmgyrion

  1 replies

  11 years, 8 months ago

  By: Jo Pattyn

• Order dates in DESC order, starting with current Month/Year

  I'm trying to get month and year output for an SSRS report using an Oracle data source for use as a…

  SqlHomebrewer

  1 replies

  11 years, 8 months ago

  By: PaulB-TheOneAndOnly

• Using OPENQUERY to joing to an Oracle table in an SSIS view fails

  I'm having a strange SSIS (SQL Server 208 R2) issue using OPENQUERY. I have created a Linked Serve…

  henry 66733

  1 replies

  11 years, 8 months ago

  By: davoscollective

• export/import error

  I am trying to load tables from sql server to oracle using import/export wizard in SQL Server. Only…

  lg123

  7 replies

  11 years, 9 months ago

  By: PaulB-TheOneAndOnly