Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Tools for a seamless export from Oracle to SQL Server

I would like to regularly copy data snapahots from a very busy and very live Oracle 8i database onto a SQL Server 2000 system.

Regular exports are taken of the Oracle database, and it would be really neat if I could import from these directly into SQL Server. This would have the benefits of a) no extra load on the live server, b) no special extract, transform and load code required, c) there would be automatic propogation of any schema changes.

Are there any tools that will enable a seamless import of an Oracle 8i export onto SQL Server. If not, why not?

None that I'm aware of. Why not? Because no one has built one.

 

For More Information

This was last published in April 2002

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close