|
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.
- Operators
- Expressions
- SELECT statement
- Insert Statement
- Update Statement
- Delete Statement
SQL Building Blocks
AdventNet 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
AdventNet 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.
Sybase
Data Type
|
SQL
Server data type |
TINYINT
|
TINYINT |
SMALLINT
|
SMALLINT |
INT
|
INT |
NUMERIC
|
NUMERIC |
DECIMAL
|
DECIMAL |
FLOAT
|
FLOAT |
DOUBLE
PRECISION
|
DOUBLE
PRECISION |
REAL
|
REAL |
MONEY
|
MONEY |
SMALL
MONEY
|
SMALL
MONEY |
DATETIME
|
DATETIME |
SMALLDATETIME
|
SMALLDATETIME |
CHAR
|
CHAR |
VARCHAR
|
VARCHAR |
NCHAR
|
NCHAR |
NVARCHAR
|
NVARCHAR |
TEXT
|
TEXT |
BINARY
|
BINARY |
VARBINARY
|
VARBINARY |
IMAGE
|
IMAGE |
| BIT |
BIT |
- Supported built-in functions:
| Index |
Built-in function |
| A |
ATAN, ASCII, ABS, ACOS, ASIN,AVG |
| C |
COL_NAME, CHAR, CHARINDEX, COUNT,
CHAR_LENGTH, CEILING, COS, COT, CAST, CONVERT, COALESCE |
| D |
DATALENGTH, DIFFERENCE, DEGREES,DATENAME,
DATEPART, DATEDIFF, DATEADD |
| E |
EXP |
| F |
FLOOR |
| G |
GETDATE |
| I |
ISNULL |
| L |
LOWER, LTRIM, LOG, LOG10, LEFT
|
| M |
MAX, MIN |
| N |
NULLIF |
| O |
OBJECT_ID, OBJECT_NAME |
| P |
PATINDEX, POWER, POWER, PI |
| R |
REPLICATE, REVERSE, RIGHT, RTRIM, RADIANS, RAND,
ROUND |
| S |
SUSER_ID, SUSER_NAME, SOUNDEX, SPACE, STR, STUFF,
SUBSTRING, SIGN, SIN, SQRT, SUM |
| T |
TAN |
| U |
USER_ID, USER_NAME, USER, UPPER |
- 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
|