SwisSQL's Oracle to SQL Server Edition is a migration tool that automatically converts Oracle PL/SQL stored procedures to equivalent Microsoft SQL Server Transact SQL code. It requires very little manual effort and automates 90% of the code conversion.
SwisSQL offers many significant features as a migration tool, including the ability to migrate Oracle PL/SQL packages, procedures, functions, triggers, cursors, tables, and views into Transact SQL. It also supports the conversion of PL/SQL In-Built Functions, SQL Queries, and all In-Built data types, including user-defined types. Additionally, SwisSQL can convert most of the Oracle built-in packages, such as DBMS_OUTPUT and DBMS_SQL, and complex query constructs like 'START WITH and CONNECT BY'.
Furthermore, SwisSQL supports the conversion of PL/SQL cursor variables, attributes, and implicit cursors into Transact SQL, and Oracle SQL queries into equivalent Transact SQL Queries, including Theta joins, DECODE, '||‘ operator, and other query constructs. SwisSQL generates formatted and readable Transact SQL code with clear comments. The software also provides an ease-to-use graphical user interface with support for a single-click-driven migration process.
SwisSQL offers two modes of conversion: it can fetch PL/SQL model directly from the database and convert them or support the conversion of PL/SQL source files loaded from a local directory. Additionally, SwisSQL provides a 30-day free evaluation along with free customer support. AdventNet, the company behind SwisSQL, provides excellent support to its customers from product evaluation to the successful completion of their migration project.
In summary, SwisSQL is a powerful and user-friendly software that can automate the tedious and error-prone manual effort required in typical migration projects. It offers many significant features that can help users migrate their Oracle PL/SQL code into Microsoft SQL Server Transact SQL with high quality and short turnaround time. SwisSQL is definitely worth considering for those who need to migrate their Oracle PL/SQL code into Microsoft SQL Server Transact SQL.
Version 2.4: N/A