Moving data from Sql server to oracle

Posted on 2008-11-18
Last Modified: 2013-12-19
Hi ,I have just one table to move from sql server to Oracle 10g .
What would be the easiest way to perform this ?
Question by:gyans
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    I would create the table on the oracle server, and with a linked server insert into that table.
    alternative would be to export the sql server table into a file that you would load with the oracle loader for example, but usually much more work.
    a third option is the reverse of the linked server (pushing from sql server to oracle), using the heterogeneous services create a dblink to the sql server database, then pulling the data from there.
    LVL 1

    Expert Comment

    This will take a lot of planning and work because all the triggers are not the same between SQL and ORACLE. Moving the data is one thing getting everything to run after you import is another. My advise is to  stick with SQL because Oracle has a lot more overhead.
    LVL 37

    Accepted Solution

    An ideal tool for this comes for free with SQL Server and is called Integration Services (SSIS).  You can use this to extract data from your SQL Server source and move it to an Oracle destination.  Although it may not be very straightforward, if you persist you've learned the usage of a very powerful tool.

    Some good info on loading data into Oracle can be found here:

    And this is a good resource on SSIS connectivity in general:

    Info on getting started with SSIS (what you need for your task is a Data Flow component):
    LVL 1

    Author Comment

    I just want one table to be extracted .
    I only need the data from the table .it oes not have any indexes or triggers or any other dependency.
    I did take it out into an excel spreadsheet. Now how do I get to import from excel spreadsheet into the oracle table .
    Would appreciate your help .
    LVL 10

    Expert Comment

    create a "LINKED-Server" to oracle.

    INSERT INTO LINK_NAME..owner.table_name
    select * from sql-server-table

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    6 Experts available now in Live!

    Get 1:1 Help Now