数据库迁移利器SwisSQL

最近在从Oracle转SQL Server开发,因此闲暇时开始查阅2个数据的区别,今天发现了一个数据库迁移的利器-SwisSQL. http://www.swissql.com/database-migration-solution.html 

AdventNet SwisSQL 是一种自动的数据库迁移解决方案. SwisSQL支持存储过程迁移, SQL 迁移和数据迁移, 其支持的数据库包括Oracle, SQL Server, IBM DB2 UDB, Sybase ASE, MySQL, Informix, and PostgreSQL, 功能非常强大,是SQL Server Editors' Chioce AWARDS  2006的金奖.

      :: SQL Query Migration Tools ::

Migrate SQL queries specific to one database dialect in your Java/J2EE, VB, VC++, COM, C#, and .NET applications across a wide range of databases such as Oracle, IBM DB2, MS SQL Server, Sybase, PostgreSQL, MySQL, Informix and Netezza.

SwisSQL Console: SwisSQL Console is a graphical user interface that helps in SQL query conversion including Schema definition, Views and Indices across database SQL dialects. DBAs and developers working with multiple databases can type/load SQL query in one database dialect and view equivalent query in other database SQL dialects.

    :: SwisSQL Console    

SwisSQL API: Embed SwisSQL API and make your Java, VB, VC++, COM, C#, and .NET applications portable across multiple databases. SwisSQL API offers options to migrate all your queries on the fly through SwisSQL API's innovative virtual JDBC/ODBC drivers or selected queries through direct API invocation.

    :: SwisSQL API (Java Edition) :: SwisSQL API (.NET Edition)           :: Data Migration Tools ::

Data Migration: Migrate schema and data automatically across a wide range of databases such as Oracle, IBM DB2, MS-SQL Server, Sybase ASE, SAP DB (Max DB), and MySQL.

    :: Data Migration           :: Stored Procedure Migration Tools ::

SwisSQL's proven and automated stored procedure migration tools helps enterprises migrate stored procedures along with Tables, Views, Indexes, and SQL statements across Oracle, MS SQL Server, IBM DB2 UDB, and Sybase ASE databases saving drastically on time and cost.

Oracle Migration: Migrate stored procedures automatically from MS SQL Server Transact SQL, IBM DB2 UDB SQL, and Sybase ASE Transact SQL to Oracle PL/SQL.

  :: SQL Server to Oracle :: DB2 to Oracle :: Sybase to Oracle    

SQL Server Migration: Migrate stored procedures automatically from Oracle PL/SQL, Sybase ASE Transact SQL and IBM DB2 UDB SQL to MS SQL Server Transact SQL.

    :: Oracle to SQL Server :: DB2 to SQL Server :: Sybase to SQL Server    

IBM DB2 UDB Migration: Migrate stored procedures automatically from Oracle PL/SQL, MS SQL Server Transact SQL and Sybase ASE Transact SQL to IBM DB2 UDB SQL.

    :: Oracle to DB2 :: SQL Server to DB2 :: Sybase to DB2    

Sybase Migration: Migrate stored procedures automatically from Oracle PL/SQL to Sybase ASE Transact SQL.

    :: Oracle to Sybase    

Java Migration: Enable your applications to support multiple databases. Migrate business logic from Oracle PL/SQL stored procedures to Java.

    :: Oracle to Java