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

    Question

  • 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 

    Daniel

    Thursday, August 14, 2014 7:40 PM

Answers

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

    David


    David http://blogs.msdn.com/b/dbrowne/

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

All replies