Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

WANT TO SYNC SQL 2008 r2 TABLES TO ORACLE 11G Expand / Collapse
Author
Message
Posted Friday, February 21, 2014 7:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 17, 2014 6:17 AM
Points: 40, Visits: 371

hi,

I have requirement from my project some of tables want to sync from sql 2008 r2 to oracle 11g

what are best way to achive this

please help me
Post #1543986
Posted Friday, February 21, 2014 8:45 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:55 PM
Points: 31,278, Visits: 15,736
You can look at replication from SQL Server. You can move data that way to Oracle. Search Books Online.

If you don't need it real time, or transaction by transaction, SSIS can easily do this as well.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1544047
Posted Friday, February 21, 2014 8:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 17, 2014 6:17 AM
Points: 40, Visits: 371

ok i will try thanks for your reply
Post #1544065
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse