Wednesday, 11 June 2008

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