Oracle DECODE and SSMA
Does the SSMA or SQL Server Migration Assistant actually have a custom DECODE function that can be used in SQL Server? I’ve installed SSMA and can’t find that function in the sysdb database. I assumed there was such a function based on a blog posting made by Kevin Kline.  If there is a function in SSMA could [...]

Answer Question   |  August 4, 2010  6:49 PM
DECODE, Oracle 9i, Oracle migration, SQL Server 2005, SSMA for Oracle

Error when translating execute immediate from Oracle to SQL
SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = ‘Avi’ /* * SSMA error messages: * O2SS0013: EXECUTE IMMEDIATE statement was converted into EXEC(…) statement, but dynamic string was not converted. It must be converted manually. * [...]

Answer Question   |  August 16, 2010  7:31 AM
O2SS0013, O2SS0356, Oracle error messages, Oracle import/export, Oracle migration, SQL Server import/export, SQL Server Migration Assistant, SSMA, SSMA for Oracle, SSMA warning messages

Oracle to SQL Server Migration – CURSOR type conversion
When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

Answer Question   |  August 25, 2008  1:42 AM
Database migration, Oracle import/export, SQL Server 2005, SQL Server import/export, SSMA for Oracle

Oracle to SQL Server Migration – User Defined data types
Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

Answer Question   |  August 28, 2008  1:38 AM
Database migration, Oracle import/export, Oracle migration, SQL Server 2005, SQL Server import/export, SSMA for Oracle