|
Release Notes for SwisSQL Sybase to SQL Server Edition
2.1
Product Features
- Ability to perform Online Migration
or Offline migration or both
- Offers Selective Migration instead of migrating an entire
database at one stretch
- View source Sybase and migrated
SQL Server code with syntax highlighting from the tool UI.
- Important migration features :
- Migration of Procedures, Triggers, Tables, Views, Indexes, and
other Sybase database objects
- Migration of Cursors and Result set processing logic
- Migration of User Defined Data types
- Migration of Sybase built-in functions
- Migration of transaction logics and syntaxes
- Migration of String, Numerical and Logical expressions
- Migration of message formats in PRINT and RAISERROR statements
- To read the complete feature
list, click here
- Tool generates formatted code, retaining comments enhancing readability
- Detailed reports generated
and output for each and every migration performed using the tool
- Option to Compile the migrated code in SQL Server database
- The tool provides a Project
driven approach for organizing all the resources associated with
a migration (viz source files, migrated files, reports and logs),
facilitating easier maintenance
- The source and migrated T-SQL files are saved as flat files, hence
the contents could be modified before migration or compilation
- Provision to generate drop scripts for migrated objects, facilitating
repeated compilation in SQL Server database
- Utility to count number of lines of Sybase code present in a File/Directory
Limitations
- Conversion of Anonymous blocks supported partially
- Error report for SQL Statements will be given near the SQL Statement
in the converted block and will not be displayed in the GUI Progression
Report.
- Refer to Manual Migration
Assistance for a list of syntaxes which are not migrated by the
tool automatically
- Auto-generated Drop scripts fails for Tables having referential
integrity constraints
- Reserved words handling (i.e. variable names which are reserved
words in SQL Server) in the migrated code has to be taken care manually
- Source and the migrated code cannot be edited from the tool GUI
Unsupported T-SQL Syntax
The Conversion of following system Global Variables
are not supported, @@char_convert, @@cis_version, @@client_csid, @@client_csname,
@@guestuserid, @@invaliduserid, @@maxcharlen, @@maxgroupid, @@maxuserid,
@@mingroupid, @@minsuid, @@minuserid, @@ncharsize, @@parallel_degree,
@@scan_parallel_degree, @@textcolid, @@textdbid, @@textobjid, @@textptr,
@@textts, @@thresh_hysteresis, @@tranchained and @@transtate
Known issues
- UI looks frozen when compiling the migrated objects in SQL Server
database. It appears frozen as the compilation happens as a background
process, the control returns back to UI after compilation of all the
selected objects
- Tool allows duplicates ie. addition of same file(s) multiple times,
for Offline migration
- Issue in connecting and fetching objects from Sybase database when
the tool is run with JDK/JRE version 1.5.0
|
