Converting Oracle dump to SQL Server or Access

Question

Hi,

I need to convert some Oracle dumps to SQL Server or Access. Does exist any free tools in order to do it, please?

Many thanks

Answer 1

Hi Pscorca

Check the below Link which is Free to Download  : Step-by-Step Migration to SQL Server 2008 R2  [ Oracle/MsAccess/MySQL/Sybase]

http://www.microsoft.com/sqlserver/en/us/product-info/migration.aspx

There us an 3rd Party tools also to do this. check the below link

http://www.convert-in.com/ord2mss.htm

 

---

Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::

Answer 2

Are you sure that SQL Server Migration Assistant is free? A license registration is required!

Thanks

Answer 3

 

Licensing

SSMA is a FREE download, and is available for use by any customer or partner with no charge or any obligations. However, the product requires a license key for activation. The key can be obtained after quick and simple registration. Microsoft reserves the right to use an e-mail address or phone number provided during registration in order to contact a customer regarding his/her SSMA experience. To help you with the registration process, a License Key Required dialog box opens the first time that you start the SSMA program

Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a tool to automate migration from Oracle database to SQL Server.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26711

SQL Server Migration Assistant (SSMA) Team's Blog

http://blogs.msdn.com/b/ssma/archive/2011/07/12/announcing-sql-server-migration-assistant-ssma-v-5-1.aspx

 

---

Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::

Answer 4

Hi Nag Pal, thanks for your suggests.

SSMA (free) doesn't open Oracle dump files and convert them for SQL Server.

The 3rd party tools in http://www.convert-in.com/ord2mss.htm aren't free.

I need to convert only few dump files.

Thanks

Answer 5

Hi pscorca,

If your dump file could be used to restore a oracle database, you can restore it first and use SSMA to migrate to SQL Server.

In ordinary, for dump file converting, you can use "OraDump to SQL" as you mentioned, but it is not free.

You can also connect the oracle support for more information.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.