Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

migration from sql server 2000 to oracle

Status
Not open for further replies.
chinna25

chinna25

Programmer
Aug 25, 2010
1
0
0
US
We have got a new project in which we have to use Informatica 8.1 for migrating all the data from SQLServer to Oracle.

So, for migrating the data should we import each and every table into Informatica and perform several different Mappings for all the tables present in SQLSERVER??

What about stored Procedures Present in SQLServer should we rewrite them in Oracle or should we design the mapping based on sp??

Kindly Suggest me the best procedure
 
Status
Not open for further replies.

Similar threads

Loanpro
  • Locked
  • Question
Passing + sign to .csv file
Replies
0
Views
37
Loanpro
Loanpro
sa0309
  • Locked
  • Question
Passing an Oracle SP error message to Informatica Email Task
Replies
0
Views
55
sa0309
sa0309
yimitz
  • Locked
  • Question
InstRev function in SQL for HIR
Replies
0
Views
43
yimitz
yimitz
rickeybj
  • Locked
  • Question
Is there a way to transfer files from and old Tandy word processor to a PC?
Replies
2
Views
50
rickeybj
rickeybj
rickeybj
  • Locked
  • Question
Is there a way to transfer files from and old Tandy word processor to a PC?
Replies
0
Views
43
rickeybj
rickeybj

Part and Inventory Search

Sponsor

Back
Top