Sql script(*.sql) migration from Oracle to SQL


  • Hello,

    I have huge scripts in Oracle that i need to migrate to SQL Server.

    My question if there some tool (microsoft sql server assistant migration only for packages/views/tables) that can convert big *.sql files from oracle to sql ? or maybe there is a easier way to do it ?

    Thank you very much 


    Thursday, August 14, 2014 7:40 PM


  • SSMA has the "Statements" node where you can add and convert individual SQL statements taken from applications or from scripts. There's no such thing in Oracle Database as a Script.

    Scripts are typically actually SQL*Plus scripts or OS shell scripts.  SSMA cannot directly convert a SQL*Plus script to a SQLCMD script, but can convert each individual SQL statement in the script.



    • Marked as answer by Danikk8 Friday, August 15, 2014 3:08 PM
    Thursday, August 14, 2014 8:47 PM

All replies