SQL Developer Migration Workbench 1.5.1

SQL Developer 1.5 released 8 weeks ago with the new Sybase capability, aiding migrations from Sybase 12 and Sybase 15 to Oracle.

It worked pretty good, and we got some great feedback from customer using it in the real world on their migration projects. All the enhancements and now provided in SQL Developer 1.5.1 released on Monday. Thanks to all.

Download it here
http://www.oracle.com/technology/products/database/sql_developer/index.html


Here are the main improvements
  • Improved Offline Data Move Scripts including support for both DATETIME And SMALLDATETIME formats
  • Variable Name Collision Management
  • Temporary Table Name Collision Management
  • Sybase Identity Columns Converted Correctly
  • Emulation Packages Improved

Many of the Issues noted by some customers regarding SQL Developer such as ORACLE_HOME issues, Connections dissapearing, NLS settings, .. are resolved.

List of Migration Bug fixes for 1.5.1
 Num      Subject
7137280  SYBASE 12 LINUX OFFLINE CAPTURE SCRIPTS NOT AVAILABLE
7129820  CANNOT DROP CONVERTED INDEXES
7113461  PROCEDURE VARIABLES NAMES ARE NOT COLLISIONED CORRECTLY
7113269  EXECUTE PROCEDURE PARAMETER NAMING INCORRECT
7046907  OFFLINE BLOB DATA MOVE "CREATE PROCEDURE" PREFERENCE SHOULD BE ON BY DEFAULT
7046890  TEMPORARY TABLE NAMES NOT COLLISIONED
7046870  CONVERTING IDENTIFIERS > 100 CHARS IN LENGHT CAUSED THE CONVERT PHASE TO FAIL
7046785  NOEXPAND TABLE HINT IS NOT RECOGNIZED
7022092  SYBASE: IDENTITY COLUMNS NOT CONVERTED TO SEQUENCE AND TRIGGER
7005215  OTNFORUMS : OBJECT/DATABASE/MODEL WORDS USED INCONSISTENTLY
6989645  IMPROVE TEMPORARY TABLE DEFINITION CONVERSION
6989465  CURSOR STATUS SHOULD BE EMULATED @@SQLSTATUS : CURRENT LIMITATION
6989025  SYBASE DATALENGTH FUNCTION NOT TRANSLATED< STILL LIMITATION
6979464  TRIGGER INSERTED REFERENCE NOT TRANSLATED CORRECTLY IN MERGE STMT
6976180  INVALID SYNTAX CAUSES THE TRANSLATOR TO LOOP/ HANG SQL DEV
6970168  EMPTY STRING AND NULL COMPARISON NOT TRANSLATED CORRECTLY
6953135  CONVERT FUNCTION NOT CORRECTLY EMULATED
6944669  DOUBLE QUOTE LITERALS NOT TRANSLATED CORRECTLY
6927102  COLUMN NAME DATA CAUSED SYNTAX ERROR
6853149  NPE DISPLAYED WHEN CAPTURE INTO EXISTING MODEL CLICKED FOR THIRD PARTY DATABASES
6853074  IN CAPTURED MODEL SELECT ALL TABLES RIGHT CLICK,RENAME & REMOVE FOLDER NOT WORKI
5903238  UPGRADE EMULATION PACKAGE
4529352  OMWB USING WRONG TEMPORARY TABLES INSIDE THE STORED PROCEDURE
3545475  OMWB FAILS TO TRASLATE " TO ' IN SOME GROUP BY EXPRESSIONS
2694450  T-SQL PARSER FAILS TO PARSE 'AFTER UPDATE' TRIGGER
7038824  NTEXT TO NCLOB ON NON UNICODE DATABASE CORRUPT WITH CHINESE CHARACTER
7013620  QUICK MIGRATE: PROVIDE INCORRECT PASSWORD, NEVER PROMPTS, JUST FAILS
6994152  ORACLE_HOME ENVIRONMENT VARIABLE SOMETIMES HAS AN ADVERSE AFFECT ON MIGRATIONS
6356767  EXCEPTION OCCURING ON CONNECTING TO A SQL SERVER CONNECTION
2694526  OMWB DOES NOT STORE DEPENDENCY INFORMATION FOR FUNCTIONS