At times even hard core Microsoft developers must sometimes work on project that use oracle.
What are the most important differences to keep in mind as a developer?
At times even hard core Microsoft developers must sometimes work on project that use oracle.
What are the most important differences to keep in mind as a developer?
Some of the points to take care 1. Basic SQL development is same as both of the dbs follow the same ANSI standards. 1. Oracle and SQL Server treat cursors differently for performance optimization 3. Different approaches when building .NET applications using the Oracle db and the SQL Server db. You can take hint from the .NET Developer Center from Oracle web site http://www.oracle.com/technology/tech/dotnet/index.html?msgid=6705607
Here's a random list to get things started:
Let me add this ubiquitous pseudo-table used in Oracle named DUAL
For example, In SQL server you will say SELECT getdate()
The Oracle equivalent will be SELECT SYSDATE FROM DUAL
I've been working with both for years, one of the biggest differences is how they each handle StoredProcedures.
Oracle has:
SQL Server: - StoredProcedures and Functions.
They also differ in:
There are some naming differences:
An oracle real application cluster (rac) with more than 1 node is always an active-active cluster. An sql server database cluster means the same but is primarly an active-passive cluster.
The SQL syntax differs in various points.
The best reference for differences is this link http://www.psoug.org/reference/sqlserver.html
No one has followed this question yet.
What are the trip of the trade when porting an application form SqlServer to Oracle?
What reference book should every DBA/Dev have?
Does a SQL Server Scripts Project work for database development?
Balancing Security with Ease of Use
How do I port a SqlServer application that uses IDENTITY columns to oracle?