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
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
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