Configuring a SQL Server to optimize for best performance
We are running SQL Server 2005 on Windows Server 2003 R2 Enterprise Edition x64 SP2. These are Dell 2950 servers with 16 GB of RAM, and they are dedicated to SQL Server. We are mainly performing large database migrations utilizing SSMA and ODBC from Sybase. How can we configure Windows and/or SQL Server to best [...]

Answer Question   |  February 3, 2009  6:04 PM
ODBC, SQL Server 2005, SQL Server performance, SSMA, Sybase, Windows Server 2003, Windows Server 2003 R2

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

Migrating data from Oracle 9i Database to SQL Server 2005
I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?

Answer Question   |  July 30, 2008  3:29 PM
Data migration, Oracle 9i, SQL Server 2005, SSIS, SSMA