Results 1 to 2 of 2

Thread: Extracting data from Oracle into SQL Server 6.5/Sybase

  1. #1
    Tony Guest

    Extracting data from Oracle into SQL Server 6.5/Sybase

    I have a coworker who needs to extract data from Oracle into SQL Server 6.5 and Sybase as part of an interface that runs daily. How is the best way to do this?

    Tony

  2. #2
    Phil McCormack Guest

    Extracting data from Oracle into SQL Server 6.5/Sybase (reply)

    If you have SQL Server 7.0, you should be able to use DTS to connect Oracle and pump the data into SQL 6.5 and Sybase.

    If you don't have SQL Server 7.0 you could generate data from Oracle in the form of Insert SQL statements (assuming not large data volumes). That is, create a SQL statement in Oracle which creates an Insert statement with the values from the tables you wish to extract from.

    MS access as a last resort. Connect to the Oracle tables, connect to the SQL and Sybase tables. Run Insert queries.

    Beware of some data-type issues.


    ------------
    Tony at 2/7/01 8:03:07 PM

    I have a coworker who needs to extract data from Oracle into SQL Server 6.5 and Sybase as part of an interface that runs daily. How is the best way to do this?

    Tony

Posting Permissions

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