Automated Migration - Supported Syntaxes

This document presents the list of Sybase constructs and syntaxes automatically migrated by the SwisSQL. Understanding how SwisSQL Sybase to SQL Server Edition works, can help users handle manual migration efficiently.

• SQL Building Blocks

1. Operators
   
2. Expressions

• SQL Statements
  

1. SELECT statement
   
2. Insert Statement
3. Update Statement
   
4. Delete Statement

• Data types
  
• Built in Functions conversion
  
• Control-of-flow language conversion
  
• Transaction statements
  
• Object types conversion
• Tables 
• Indexes 
• Views
• Stored Procedures
• Triggers
  
  

SQL Building Blocks

SwisSQL Sybase to SQL Server handles all arithmetic, bitwise, comparison operators and expressions. The tables list the operators and expressions handled by the tool.

Arithmetic operators :

+, -, *, /, %

 

Bitwise operators :

 

&, |, ^, ~

 

Comparison operators :

=, >, <, >=, <=, <>, !=, !>, !<

Expressions :

• Case expression, Integer expressions, Character expressions, Logical expressions
  
  

• SQL Statements

  SwisSQL Sybase to SQL Server supports SQL statement conversions supporting various clauses of SELECT statements, with INSERT, UPDATE, and DELETE statements.
  
  

• SELECT statement
  
  Supported clauses
  
  
  • ALL, DISTINCT keywords in select list
    
  • FROM clause
    
  • WHERE clause
    
  • GROUP BY and HAVING clause
    
  • ORDER BY clause
    
  • INTO clause
    
  • FOR UPDATE OF clause
    
    
• INSERT statement
  
  
  • Insert with VALUES clause
    
  • Insert with SELECT statement

     

• UPDATE statement
  
  
  • UPDATE clause
    
  • SET clause
  • FROM clause
    
  • WHERE clause
    
    
• DELETE statement
  
  
  • Delete clause
    
  • FROM clause
    
  • WHERE clause
    
    
• Data Types : The data type mapping table will help you understand how Sybase ASE data types are mapped to equivalent Server data types during migration.

• Supported built-in functions:
  

• Control-of-flow language conversion
  
  Supported constructs :
  
  
  • IF ELSE statement
    
  • CASE statement
    
  • BEGIN .. END block
    
  • WHILE statement
    
  • BREAK and CONTINUE statements
    
  • GOTO statement
    
  • RETURN statement
    
  • PRINT statement
    
  • RAISERROR statement
    
    
    
• Transaction statements
  
  
  • BEGIN Transaction
    
  • SAVE Transaction
    
  • COMMIT Transaction
    
  • ROLLBACK Transaction
    
    
    
• Object types conversion
  
  
  • Tables, Temporary Tables
    
  • Indexes
    
  • Views
    
  • Stored Procedures
    
  • Triggers