An Oracle DBA moving to SQL Server asked me how instances differ between the two products. Here is what I told him, and when to use which approach.
SQL SERVER – SSMA Error : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
I said I have no clue as to why this is happening and I asked if it was in any way related to SQL Server? Let us fix SSMA Error.
Translating Oracle CONNECT BY Queries to Recursive CTEs
Translate CONNECT BY into recursive CTEs with root selection, depth, paths, sibling ordering, cycle checks, and a recursion limit.
SQL SERVER – SELECT * FROM dual – Dual Equivalent
Oracle developers often miss the DUAL table in SQL Server. I explain what DUAL is, why SELECT * FROM dual fails with Msg 208, and the dual equivalent to use.
SQL Server for Oracle DBAs: The Vocabulary
SQL Server for Oracle DBAs translates instance, database, schema, tablespace, undo, and redo without pretending the two architectures are identical.
Oracle to SQL Server: Translating NVL, ROWNUM and Sequences
Translate Oracle to SQL Server expressions for NULLs, row limits, dates, sequences and concatenation, and test where they differ.
SQL SERVER – Fix Error 9803. Invalid data for type “numeric” – Data Type Mapping
My present article talks about an error that you will encounter when connecting to Oracle database using OPENQUERY. Let us learn about how to fix error 9803.