Review of SwisSQL Sybase to SQL Server

Short Description
from Microsoft SQL Server, Sybase, Oracle, IBM DB2, Informix, MySQL, PostgreSQL and ANSI SQL. … This tool automates the typically painful and manual …

Website: www.swissql.com | Filesize: 176kb

Content
In a previous review, I looked at SwisSQL SQLOne Console from AdventNet, that converts SQL statements
from one SQL dialect to another. That’s a generic SQL Converter and supports conversion to and
from Microsoft SQL Server, Sybase, Oracle, IBM DB2, Informix, MySQL, PostgreSQL and ANSI SQL.
Now it’s time to review yet another migration related product from AdventNet. It is called “AdventNet
SwisSQL Sybase to SQL Server Migration Tool 2.1″. As the name suggests, this migration product automates
the conversion of Sybase ASE (Adaptive Server Enterprise) T-SQL stored procedures, inbuilt functions,
triggers, tables, views, and other database objects to Microsoft SQL Server T-SQL.
You might question the use of a migration tool that converts Sybase T-SQL to Microsoft SQL Server TSQL,
as both these dialects are very similar. In fact, Microsoft SQL Server has evolved from Sybase. Even
though both Sybase and Microsoft went different ways with their RDBMS platforms, their T-SQL implementations
still share commonalities. At the same time, both Microsoft and Sybase have enhanced and
improved their T-SQL implementations with their own extensions. This is where a product like SwisSQL
Sybase to SQL Server Migration tool comes into play. This tool…