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
Printable View
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
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