Background: A sign in Oracle changed to SQL Server
Workaround:
1, first think of Microsoft's solution:
Microsoft SQL Server Migration Assistant v7.4 for Oracle
https://www.microsoft.com/en-us/download/details.aspx?id=54258
According to the introduction looks very cow B, installed after the death of the United not Oracle, told me to install Oracle Provider link Library, from 10 to 12, a variety of clients, various types of libraries I have installed, finally I gave up.
2, helpless replacement of third-party solutions:
ESF Database Migration Toolkit Pro 8.2.07
Http://www.0daydown.com/11/266995.html
This is the real cow B, sub-type installation completed, connected to two databases, began to guide the table, guide the data, incredibly brought the note, the more than SQL Server itself to import the data function much better.
ESF Database Migration Toolkit Professional is a program this allows you to convert between different Database formats. ESF Database Migration Toolkit Professional can directly connect to MySQL, SQL Server, PostgreSQL, Oracle, Access, Excel, Paradox, Lotus, DBase, Visual FoxPro, Text and other formats, and convert between these formats (SQL Server to MySQL, mysq L to Access etc.).
The rest of the triggers, stored procedures Let's do it manually.
(formerly) migrating Oracle to SQL Server