none
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

    Question

  • 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
    Monday, April 30, 2012 2:12 PM

Answers

All replies