Q

Sending data from Oracle database to SQL Server

I want to send data (rows from a table) from an Oracle database to SQL Server. Is there an optimal way to do that?

I want to send data (rows from a table) from an Oracle database to SQL Server. Is there an optimal way to do t...

Step 2 of 2:

hat?

There are a few methods worth exploring. When going from Oracle to SQL Server, it has always worked best for me to use SQL Server's Data Transformation Services (DTS). Install Oracle client on the SQL Server database server and configure an ODBC definition to point to that Oracle instance. Fire up SQL Server's Import and Export Wizard (DTS Wizard) and choose ODBC as your data source. You can then navigate to the Oracle table. Choose the SQL Server destination table and let the DTS wizard do the work for you!

This was last published in September 2005

Dig Deeper on Oracle and SQL

All
News
Get Started
Evaluate
Manage
Problem Solve

PRO+

Content

Find more PRO+ content and other member only offers, here.

E-Handbook

Cloud-based database software adds new IT options for users

Have a question for an expert?

Please add a title for your question

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

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

Start the conversation

Send me notifications when other members comment.

-ADS BY GOOGLE

SearchDataManagement

Big data systems up ante on data quality measures for users

At the Strata conference in New York, IT managers detailed steps they're taking to improve data quality in their big data ...
Cloud database services get stronger push from Microsoft, Oracle

Using cloud databases is now more a matter of when than if at many companies. There's also the question of how, as Microsoft, ...
Managing the big data ecosystem requires agility amid disruptions

In some regards, the term big data management can be viewed as an oxymoron. In fact, oxymorons abound in this industry and...

SearchBusinessAnalytics

Machine learning in the cloud forces hard big data decisions

Interest in implementing a cloud machine learning platform is up, but not every business is sold on the benefits of this emerging...
Natural language generation software making inroads in enterprises

Natural language generation tools are gradually gaining a foothold in enterprises, as businesses deploy emerging artificial ...
AI hype doesn't stop Trulia from using new analytics tools

Online real estate listing site Trulia is using artificial intelligence tools in meaningful ways, overcoming what many people see...

SearchSAP

Why SAP Leonardo depends on design thinking methodology

In this Q&A;, SAP's Mike Flannagan explains the evolving nature of SAP Leonardo and how a design thinking process can help ...
Swisscom makes gains by shrinking data warehouse systems

When Swisscom needed to merge two SAP ERP systems and several SAP BW data warehouses, it upgraded to one SAP BW on HANA system to...
Swisscom makes gains by shrinking data warehouse systems

SearchSQLServer

Dissect the SQL Server on Linux high availability features

SQL Server 2017 on Linux gives IT shops greater flexibility, but there are some limitations and changes to the way high ...
Microsoft SQL Server 2017 for Linux hits GA, IT pros encouraged

Microsoft SQL Server 2017 becomes available in October. In addition to a version that runs on Linux, new features include support...
SQL Server graph database tools map out data relationships

Get equipped to take advantage of the addition of graph database features in SQL Server 2017 to use graph structures to represent...

TheServerSide.com

Azure Functions, Project Fn shine at JavaOne 2017

At JavaOne 2017, Microsoft previews its Azure Functions serverless offering with support for Java; Oracle introduces Project Fn, ...
Manico and Grimstad bring Java tech to life at JavaOne 2017

Engaging speakers like Jim Manico or Ivar Grimstad can make all the difference when choosing a session at a conference like ...
Guide to the JavaOne 2017 conference

At JavaOne 2017, the Java community discusses the pinnacles of modern software technologies, including DevOps, mobile ...

SearchDataCenter

Remain relevant as a data center specialist

Handling a variety of roles and possessing a multitude of skills make data center specialists a key cog in the IT machine as ...
Hybrid cloud platforms look to liberate VMware, Azure tie-in

Vendor-focused hybrid cloud platforms such as VMware Cloud on AWS and Microsoft Azure Stack get a lot of attention, but some new ...
How to choose a live kernel patching extension

Ksplice and kpatch offer similar live kernel patching services on a Linux system, but differences between function-level services...

SearchContentManagement

Content personalization fuses marketing automation, content management

As the standards get higher for digital experiences, content personalization engines could be the answer for faster and better ...
Microsoft SharePoint use grows despite product maturity

SharePoint, introduced in 2001, isn't going anywhere, despite challenges from Box, Dropbox and other cloud rivals. A Microsoft ...
The Pipeline: Brand content marketing strategies from Digital Strategy Summit

Branded content and social media were the main talking points at the Digital Strategy Summit, a conference dedicated to content ...

SearchFinancialApplications

Finance IT case study: Reporting secrets of Derek Rose

CEO Sacha Rose says specialist reporting tools have saved the company thousands by avoiding unnecessary mistakes.
WestJet turns to gamification to help its Oracle ERP users soar

WestJet's initial gamification project focuses on expense reporting.
The Transformation of HR is Underway

HR is being transformed while we watch.

Close