Oracle Database Discussions

Hi,

We are in process to convert our client-server application into web-based. My current application is using Oracle database and in my team I have sufficient resource of oracle skillsets.

Due to the Rich user interface requirement, we decided to develop our application into .Net with Oracle(instead of Java & Oracle). But while presenting this solution, our engg board has raised this question that Why Oracle with .Net. You should use SQL server with .Net as both are Microsoft products. Moreover they raised the issues that we may face integration issues between .Net and oracle

In answer to this I explained following things which are not good enough to convince my engineer board.

Advantages of .NET
• Rich user interface
• Microsoft office integration
• OLE being inherent Microsoft technology, .NET platform can integrate OLE easily.
• Less overhead on development time of rich user interface as opposed to Java, and meeting of business goals.

Oracle with .Net

Tightly integrated with Oracle through ODP.NET (Oracle Data Provider) -Being a Data Centric Application, this feature would be a key component in .NET architecture.

Why not SQL Server?

• Current application is on Oracle and it would be very easy to migrate the data to new Oracle environment rather than SQL server. Lead time would be more in data transfer between oracle and sql server
• Current team has Oracle skills.
• SME are having confidence in Oracle as they have been using it for years...
• Automatic auditing and flashback data (Historical data fetch) is not available in SQL Server and we would require this functionality in order to meet business requirement.

Could anyone please help me to provide some more point why I should go for oracle.