Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle data migration

940057May 28 2012 — edited May 28 2012
Hello,

1. What is the best way to migrate data from sqlserver 2008 to oracle 11g R2? We need to migrate 200 stored procedures written in sqlserver along with 5Tb of data.

2. Does Oracle 11gR2 with R language work on normal unix (Redhat 64bit machines) or this need seperate hardware appliance from oracle? Any links?

Thabjs

Comments

SHANOJ
hope this link may help you:

1097037

regards
713555
golden gate is a great product. Ive used GG to migrate from Sqlserver to oracle. Im not saying GG is the best product for this. Im just saying Ive used it and it works. Damn well

http://www.oracle.com/technetwork/articles/datawarehouse/oracle-sqlserver-goldengate-460262.html

R will install on 64 bit linux, instructions

http://docs.oracle.com/cd/E27988_01/doc/doc.112/e26499/install.htm#BABBJEBJ
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 25 2012
Added on May 28 2012
2 comments
184 views