SwisSQL- SQL Server to Oracle Edition automates the conversion of Microsoft SQL Server Transact SQL stored procedures to Oracle PL/SQL code. With over 80% of code conversion automated, manual effort is significantly reduced.
SwisSQL eliminates the need for time-consuming, tedious, and error-prone manual effort typical of most migration projects. It provides a great productivity benefit with high-quality output and a short turnaround time. The tool offers migration of SQL Server Transact SQL procedures, functions, triggers, cursors, tables, and views into PL/SQL.
Additionally, it supports conversion of all In-Built Functions, SQL queries, and all In-Built data types, including user-defined types. The software also supports the conversion of all Transaction features and Temporary table features into PL/SQL. The tool supports most '@@' global variables into equivalent PL/SQL implementation and has support for Result-Set Processing conversion from Transact SQL to PL/SQL.
One great benefit of this software is that it generates formatted, readable PL/SQL code with very good comments. It also provides an ease-to-use graphical user interface with support for single click-driven migration. The migration tool supports two modes of conversion; it could fetch Transact SQL model directly from the database and convert them, or it can convert Transact SQL source files loaded from a local directory.
All in all, SwisSQL - SQL Server to Oracle Edition is an excellent tool that simplifies database migration projects, saves time, and delivers high-quality output.
Version 3.5: N/A
Version 3.2: N/A