What is difference between ORACLE and SQL-SERVER

What is difference between ORACLE and SQL-SERVER ?

1. Oracle runs on many platforms, SQL on Windows only.
2. Oracle includes IFS (Internet File System), Java integration; SQL is more of a pure database.
3. Oracle requires client install and setup (Not difficult, but very UNIX-like for Windows users)
4. SQL is #1 in Cost/Performance and overall Performance, although Oracle will refute that.
5. Replication is much easier in SQL.

6. Failover support in SQL is much, much easier
7. JDBC support is much better in Oracle, although Microsoft is working on it 
8. ODBC support in both.
9. SQL is ANSI-SQL '92 compliant; making it easier to convert to another ANSI compliant database, theoretically anyway (truth is every database has proprietary extensions). Oracle is generally more proprietary and their main goal is to keep their customers locked-in.
10. SQL natively supports ODBC, OLEDB, XML, XML Query, XML updates. Oracle natively supports proprietary connections, JDBC. Not sure about XML support though.
11. SQL Server is much easier to administrate, with GUI and command- line tools. Most of Oracle is command-line (Back in SQL, 12 days I had a customer (at Kolkata) who was so proud that after a day's worth of work he had managed to script his database. I showed him how it was a 3 click operation in SQL.
12. Oracle requires add-ons for transaction monitors, failover, etc. SQL has COM+, uses NT clustering and generally has everything built-in.
13. SQL Analysis Services is included (A very powerful OLAP server). For Oracle it is a separate purchase.

Hope this post help you to select right database for your Access Control System, Attendance System, Video Analysis etc.

MS SQL SERVER VS ORACLE 10G COMPARE

COMPARE MS SQL SERVER VS ORACLE 10G

SQL Server:

Pros:

Its easy installation, self-tuning capabilities, graphical administration, integrated business intelligence and extensive collection of help wizards

The total cost of ownership (TCO) of SQL Server 2005 is lower than that of Oracle

Specialized index on a computed column

Indexed View

Cons:

Locking and concurrency: SQL Server has no multi-version consistency model, which means that "writers block readers and readers block writers" to ensure data integrity

Performance and tuning:

a. DBA has no "real" control over sorting and cache memory allocation. The memory allocation is decided only globally in the server properties memory folder, and that applies for ALL memory and not CACHING, SORTING, etc.

b. All pages (blocks) are always 8k and all extents are always 8 pages (64k). This means you have no way to specify larger extents to ensure contiguous space for large objects.

c. In SQL Server, no range partitioning of large tables and indexes. In Oracle, a large 100 GB table can be seamlessly partitioned at the database level into range partitions.

With SQL Server 2005, INSERT, UPDATE, and DELETE statements are executed serially (MERGE is not supported).

Oracle:

Pros :

you can use Oracle on multiple platforms. Whereas Microsoft created SQL Server to be used on the Microsoft platform only, Oracle is available on multiple platforms, including Windows, Unix and now Linux, which is the foundation of Oracle's Real Application Clusters (RAC) strategy.

Locking and concurrency: "readers don't block writers and writers don't block readers." This is possible without compromising data integrity because Oracle will dynamically re-create a read-consistent image for a reader of any requested data that has been changed but not yet committed. In other words, the reader will see the data as it was before the writer began changing it (until the writer commits).

function-based indexes

Oracle will execute INSERT, UPDATE, DELETE, and MERGE statements in parallel when accessing both partitioned and non-partitioned database objects

Cons:

"Implementation of something similar to MSSQL Identity by using Oracle sequence would require reflecting the sequence name in the application or creating a trigger for each table/sequence pair.

Cost is higher

Required skilled DBA.

CONCURRENCY MODEL

concurrency control. The main differences are summarized in the table below:

Oracle Database 10g SQL Server 2005

Multi-version read consistency Always enabled. Not by default.

Must be enabled.

Non-escalating row-level locking Yes Locks escalate

SQL Server 2005 introduces two new isolation levels3:

read committed with snapshots (statement-level read consistency)

snapshot isolation (transaction-level read consistency)

These isolation levels correspond to Oracle’s READ COMMITTED and SERIALIZABLE isolation levels, respectively.