Toad World® Forums

Oracle to SQL Server


#1

Hi All,

I don’t know if I am posting it on a right forum but here’s my question for you guys:
I want to export oracle database into SQL Server. How can I accomplish that?

I will be good even if I am able generate SQL scripts of the tables.

Thanks,
Attiqe


#2

Hi,

click File | Sync and Convert | Sync and Convert Wizard…
or File | Sync and Convert | Simple Model Conversion…

If you want to convert Oracle database structure to SQL Server model, the conversion will correctly convert tables and data types and also sequences/identities. Code of stored procedures and other database specific items can be automatically commented out.

Regards,

Vaclav


#3

I did a migration of a CRM database based on oracle to ms sql server using the tool

Oracle2MSSQL by Intelligent Converters

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

It is very powerful an comfortable, yet it needs some time to do it’s work. I think it took about 30min to migrate ca. 200.000 rows of data.
But it can migrate

  • data
  • contraints
  • foreign keys
  • indexes

Nils