Post reply

Oracle data to Sql server

  • November 15, 2011 at 3:31 am

    #247808

    As per my requirement i have to move ORACLE data (objects:tables ) to Sql server..

    I shall be thankful if anyone tel me how to migrate the data from oracle to Sql server..

    Is there any tool for that or any other process?

    Thanks

  • November 15, 2011 at 4:02 am

    #1407727

    You could use the migration assistant or simply SSIS.

    If you're not comfortable with SSIS, you can set it up with the Import/Export wizard and save it as package for further tweaking.

    Hope this helps

    Gianluca

    -- Gianluca Sartori

  • November 15, 2011 at 4:20 am

    #1407737

    Okay...For working with SSIS first can i create linked server between sql server to oracle and then proceed or directly can i use the ssis for migrating oracle data to sql server with out creating linked server..

    Thanks

  • November 15, 2011 at 5:44 am

    #1407772

    could anyone provide the step by step process for migrating the oracle data(only specific objects) to Sql Server using SSMA tool..

    Thanks

  • November 15, 2011 at 5:55 am

    #1407780

    rocky@123 (11/15/2011)

    could anyone provide the step by step process for migrating the oracle data(only specific objects) to Sql Server using SSMA tool..

    Thanks

    looks like there is a series of videos here with step by step instructions for the Oracle SSMA; the first video is 3.5 minutes long, and he specifically mentions the "schema converter" in the intro.

    http://www.microsoft.com/en-us/showcase/details.aspx?uuid=2cc2e29e-b730-4a56-bcd7-6f62496f2431

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 15, 2011 at 6:01 am

    #1407792

    if you watch the first video, it does a quick demo showing how the schema is migrated, and then how data requires a seperate click/call, so you'll get your new schema migrated first, then data if you want.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 15, 2011 at 6:05 am

    #1407798

    rocky@123 (11/15/2011)

    Okay...For working with SSIS first can i create linked server between sql server to oracle and then proceed or directly can i use the ssis for migrating oracle data to sql server with out creating linked server..

    Thanks

    No, don't create the linked servers. Let SSIS copy data, it's much faster.

    -- Gianluca Sartori

  • November 17, 2011 at 3:01 am

    #1409046

    Thanks Gianluca Sartori & Lowell ..

    I want to go by SSIS for migrating Oracle data(only tables) to Sql Server rather than by SSMA ..

    I don't know SSIS much..Is there any task or transformation for doing this ...

    How can we migrate the data using SSIS ..Is it first need to establish any connection to oracle and sql server or not?

    can we take manually exp in oracle and save it into some execl files and finally import in sql server?

    Please give me some documents or step by step process for migrating (using SSIS)..

    Thanks

    Geetha

  • November 17, 2011 at 3:28 am

    #1409056

    import/export method is also ok for me

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply