|
Release Notes for SwisSQL Sybase to SQL
Server Edition 2.5
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
|
