January 26, 2010 at 4:10 am
Hi all, I have an Oracle dmp file and need to import and I'm looking for suggestions. So far I have one 3rd party tool from intelligent-convertes called Oradump
but its help file is thin and I would like to compare against something else.
Does anyone have any suggestions that they have used?
Cheers
Allen
January 26, 2010 at 9:09 am
I've never heard of a tool that imports a .dmp file to SQL Server and the product you mentioned sure doesn't give much information. I didn't even see anything on their site that confirmed that product converts an export file i.e. .dmp rather than a backup files i.e. dump.
If you have access to the actual Oracle database, you could use SSIS to import directly into SQL Server.
Greg
January 26, 2010 at 9:37 am
Hi Greg, thanks.
I can confilrm it loads a .dmp, I ran their demo software but it is limited to 5 records per table so gives no idea of performance!
I was trying to avoid loading to an Oracle instance. The only one I have is the free version which is limited to 4GB of data.
Cheers
Allen
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply