Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
For migration of data from oracle to sql server 2008 r2 which option is better (1) SSIS trough import/export wizard or (2) linked server

Answered For migration of data from oracle to sql server 2008 r2 which option is better (1) SSIS trough import/export wizard or (2) linked server

  • Monday, April 30, 2012 2:12 PM
     
     
    Sign In to Vote
    0

    For migration of data from oracle  to sql server 2008 r2

    which option is better and why

    (1) SSIS  through import/export wizard or

    (2) linked server

    as i have to migrate some 10000 records from oracle db.. to sql server 2008 r2  as  the oracle db server is adding and updating the data very frequently and  that same  updated or inserted data should reflect in sql serve also



    • Edited by arctest123 Monday, April 30, 2012 2:13 PM
    •  
     

All Replies

  • Tuesday, May 01, 2012 9:16 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi arctest123,

    I would recommend you create a SSIS package to synchronize data from Oracle to SQL Server. Meanwhile, you can schedule a job to execute this pack periodically. For your reference: Using SSIS to get data out of Oracle: A big surprise!

    Stephanie Lv

    TechNet Community Support

     
  • Tuesday, May 01, 2012 9:25 AM
     
     
    Sign In to Vote
    0

    Could you please go through the below link, it may help you out.

    http://expressnetsolutions.com/sqldch/?p=92