July 8, 2009 at 11:30 pm
hi,
Can I restore a dump taken in Oracle into SQL Server 2005? If yes, how? Any suggestion will be appreciable...
Thanks
January 6, 2010 at 1:08 am
as per my knowledge ,it is not possible to directly import .dmp file to sql server.
we need to use a third party tool.like
January 7, 2010 at 4:43 pm
lingaraj.sarangi (1/6/2010)
as per my knowledge ,it is not possible to directly import .dmp file to sql server.we need to use a third party tool.like
Yes, you will need to use a third party tool.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 7, 2010 at 5:15 pm
I believe informatica is one such tool that can do this.
---------------------------------------------------------------------
January 8, 2010 at 9:27 am
Hi,
If by 'dump' you mean an export file (.dmp), then you will need to import it into an Oracle database first. Then you could create a linked server etc. for data movement to SQL Server.
If you don't have Oracle in your organisation, install the free Express edition http://www.oracle.com/technology/products/database/xe/index.html on your PC, and import the .dmp using the 'imp' command at the C: prompt. HTH
January 9, 2010 at 6:54 am
Be aware
"Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine."
4 GB of user data is not very much.
I had the same situation and managed to find a company in my vincity which had Oracle and SQL Server where
I for a small amount of money could set up a linked server combination and move the data.
/Gosta
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply