[VIEWED 5015
TIMES]
|
SAVE! for ease of future access.
|
|
|
Motherland
Please log in to subscribe to Motherland's postings.
Posted on 11-04-09 3:41
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Guys Any tool or process which can be used to copy data from Oracle db to MSSQL Server 2008 db. I am looking for the fastest and most efficient way to migrate the data. Any help or advice will be appreciated.
|
|
|
|
mampakha
Please log in to subscribe to mampakha's postings.
Posted on 11-04-09 3:49
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Motherland, SQL Server 2008 SSIS is the best for this purpose. Have you tried that one?
|
|
|
Motherland
Please log in to subscribe to Motherland's postings.
Posted on 11-04-09 4:35
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Thanks! mampakha Well I have tried SSIS and BCP too. I was wondering what other tools we can use.
|
|
|
forcontact
Please log in to subscribe to forcontact's postings.
Posted on 11-04-09 8:10
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Bro this link should have some solution http://sqlcat.com/technicalnotes/archive/2008/08/09/moving-large-amounts-of-data-between-oracle-and-sql-server-findings-and-observations.aspx
|
|