How can I export data from SQL Server and import it into Oracle?

by Ari Weil

You want to create a distributed query. This is a very common, and relatively simple process from a SQL Server standpoint.

From the SQL Server side you can add a linked server then access the external data by using OPENDATASOURCE.

From the Oracle side you might want to have a look at the Oracle Migration Workbench.

Tags:



Related Posts

  1. How can I synchronize data between MS Access and SQL Server databases? Basically, you want to create a distributed query. This is...
  2. After a recent upgrade to SQL Server 2005 my linked server export to Oracle 10g no longer gives me the option of deleting first or appending. Any clues? More: Since there are 3 machines in this mix so...
  3. How do I query DB2 data from SQL Server? Q:  We use DB2 Connect to access DB2 from MS...
  4. How can I export data to csv format in SQL Server 2005? The easiest way to do this would be to use...
  5. Product Watch: Scalable SQL Server Grid with XKoto. Could this be MSSQL’s answer to Oracle RAC? Microsoft SQL Server has been advancing technologically on every front...

About This Post

  • Digg
  • del.icio.us
  • DZone
  • DotNetKicks
  • Google Bookmarks
  • Ping.fm
  • Reddit
  • StumbleUpon
  • TwitThis
Share this post with friends

Leave a Reply