SwisSQL - Sybase to SQL Server Migration Tool 2.1
Written by yangying   
April 29, 2008 10:38

 


 


 
 
SwisSQL Sybase to SQL Server Migration Tool offers over 95% automation and over 80% savings on the migration cost, offering basic as well as advanced automated conversion features


Basic Object Type Conversions
  • Stored Procedures
  • Triggers
  • Tables
  • Views
  • Indexes
  • User Defined Data types
Key Conversion Features
  • Cursors and Result set processing logic
  • Built-in functions
  • Transaction logic
  • SQL Statement conversions covering all DDL (Create, Alter, Drop, ..) and DML (Insert, Update, Delete, Select, ..) statements.
  • String, Numerical, and Logical expressions
 


SwisSQL Solution for the Complete migration Cycle

SwisSQL Sybase to SQL Server Migration Tool helps you through the complete migration cycle from fetching the database objects to compiling the migrated objects into the SQL Server database.

Loading Sybase objects

You can load Sybase database objects into SwisSQL Sybase to SQL Server Migration Tool using the following methods

  • Online migration: SwisSQL Sybase to SQL Server offers an intuitive wizard that helps you to directly connect to the Sybase database in your network. It helps you to connect to the Sybase database using either JDBC connection or ODBC connection. You can fetch the required database objects that are to be migrated from the connected live Sybase database.
  • Offline Migration: You can directly load Sybase database objects in your local folder and migrate them to SQL Server.

Migrating Sybase Transact-SQL objects to SQL Server Transact-SQL

SwisSQL Sybase to SQL Server Migration Tool offers more than 95% automated migration of Sybase Transact SQL objects to SQL Server Transact SQL objects ensuring the integrity of the converted application logic. The tool handles the conversion of procedures, triggers, tables, views, indexes, conditional and control statements, inbuilt functions, transaction statements, SQL statements and other Sybase database objects. View the supported features

Deploying the migrated SQL Server Objects

SwisSQL helps you connect to any SQL Server database in your network and compile the migrated objects into it. With a one-time configuration, you can compile all the SQL Server objects. You could even edit the migrated objects manually, fine tune it to suit your requirement before being deployed into your SQL Server database

Detailed Migration Reports

SwisSQL offers Detailed Migration reports after migration, which provides users with information about the migrated database objects and not migrated database objects. SwisSQL also generates well defined comments within the migrated code that helps users to understand how the migration was handled by the automated tool.

Migration Assistance

SwisSQL migrates over 95% of your application code, with the rest of the migration needing very minimal manual assistance. You could refer to the detailed help documentation for assistance on handling the manual migration. For further technical support you can contact our technical team at support@swissql.com

Supported Database Versions


Source DatabaseTarget Database
Sybase ASE 12.xMS SQL Server 2000