How to migrate from Microsoft SQL Server to an Oracle Database 12c centralized environment with ODP.NET
By margaret hamburger-Oracle on Mar 28, 2014
Recently the Federal Tax Service of Russia migrated from their Microsoft SQL Server environment to an Oracle Database 12c centralized environment with the help of ODP.NET.
The Federal Tax Ministry of Russia is a national government agency located in Moscow. It operates nine regional offices that oversee major taxpayers with a wide network of local offices that employ 140,000 people.The ministry is in the process of migrating from Microsoft SQL Server to Oracle Database 12c technology and Exadata. Its goal is to centralize all fiscal data access, improve performance, and reduce storage costs, while continuing to keep its investment in a Microsoft .NET infrastructure.
Oracle Database 12c makes developing and deploying Oracle on Windows and .NET easier, faster, and more cost-effective. By using Oracle’s .NET components (ODP.NET), the tax ministry can adopt new Oracle Database 12c features for their .NET applications. The migration to Oracle so far is meeting their goal for centralized data access and provides 20x better performance with a tenfold reduction in storage costs.
Listen to this Database Insider Podcast Interview for more details about their migration from Microsoft SQL Server to Oracle Database 12c.