Results 1 to 4 of 4

Thread: SQL Server / Oracle Gateways

  1. #1
    Robert Griffiths Guest

    SQL Server / Oracle Gateways

    Does anyone have any experience of using db gateways between SQL Server
    and Oracle? I am interested in creating 'virtual' databases with such
    tools.

    Any good or bad experiences would be appreciated......

  2. #2
    Norman Boisvert Guest

    SQL Server / Oracle Gateways (reply)

    We are using Oracle SQL gateway to move data between Oracle 7 and SQL 6.5
    There are occasions were this gets flakey, so I would approach with caution.
    I guess I don't know what you mean by a 'virtual database'
    We have some problems with tempdb filling up during prolonged data transfers from Oracle to SQL server. We workaround this by throttling the datafeed to a certain # of records and dropping the Oracle connection.
    It is almost like Oracle "commits" aren't getting through.




    On 2/10/99 4:12:40 AM, Robert Griffiths wrote:
    > Does anyone have any experience of using db gateways between SQL
    > Server
    and Oracle? I am interested in creating 'virtual'
    > databases with such
    tools.

    Any good or bad experiences would be appreciated......

  3. #3
    John Thorpe Guest

    SQL Server / Oracle Gateways (reply)

    SQL Server 7.0 allows Oracle databases to be linked and queried with transact SQL as if they were SQL Server databases.

    Also Data Transformation Services in SQL7 allows data movement from/to Oracle and any OLEDB supported database.

    On 2/10/99 4:12:40 AM, Robert Griffiths wrote:
    > Does anyone have any experience of using db gateways between SQL
    > Server
    and Oracle? I am interested in creating 'virtual'
    > databases with such
    tools.

    Any good or bad experiences would be appreciated......

  4. #4
    Robert Griffiths Guest

    SQL Server / Oracle Gateways (reply)


    On 2/15/99 11:00:09 AM, John Thorpe wrote:
    > SQL Server 7.0 allows Oracle databases to be linked and queried with
    > transact SQL as if they were SQL Server databases.

    Also Data
    > Transformation Services in SQL7 allows data movement from/to Oracle and any
    > OLEDB supported database.

    On 2/10/99 4:12:40 AM, Robert Griffiths wrote:
    >
    > Does anyone have any experience of using db gateways between SQL
    >
    > Server
    and Oracle? I am interested in creating 'virtual'
    >
    > databases with such
    tools.

    Any good or bad experiences would be
    > appreciated......

    Thanks for this.

    Do you know what versions of Oracle this works with? Oracle has a 'gateway' product that makes
    a SQL Server db look like an Oracle db, but this only works with Oracle 8.

    We are going to be using Oracle 7.3. Does the SQL Server 7.0 gateway work with that?


Posting Permissions

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