我应该考虑从SQL Server迁移到Oracle为我的ASP.NET应用程序？ [英] Should I consider migrating from SQL Server to Oracle for my ASP.NET applications?

问题描述

我们正在升级我们的系统，支持集群和自动的失效转移功能。我们的业务运行.NET 4的应用程序，Web应用程序和服务上的SQL Server防爆preSS。我们可以升级到SQL Server标准，但成本已促使我们去考虑其他的选择。它是我们的.NET数据层集成ODP.NET一个合法的选择吗？搜索后，我已经看到了一个否定的倾向性陈述或两个（<一个href=\"http://stackoverflow.com/questions/7902160/best-way-to-migrate-a-windows-forms-application-from-sql-server-to-oracle\">viz)然而它似乎人反正正在这样做。我们将失去什么发展特点，在Visual Studio IDE中？感谢您的帮助！

We're upgrading our systems to support clustering and auto failover features. Our business runs .NET 4 applications, web apps and services on SQL Server Express. We can upgrade to SQL Server Standard, but the cost has motivated us to consider other options. Is it a legitimate option to integrate our .NET data layer with ODP.NET? After searching, I have seen a tendentious statement or two in the negative (viz) and yet it would seem that people are doing it anyway. What development features in the Visual Studio IDE will we lose? Thanks for your help!

推荐答案

好吧，我现在因为20多年与Oracle和MS SQL Server的工作，已经做了很多项目。有些项目现在超过10年的运行，所有的更新，维护等。

Well, I'm now working since 20+ years with Oracle and MS SQL Server, having done a lot of projects. Some projects are running now more than 10 years, with all the updates, maintenance and so on.

我快速的回答是：了解最新的MS SQL Server中。只能去到Oracle，如果你有很好的技术原因，或者如果您打算真的一个庞大的数据库，如果你有足够的工作人员来处理所有thge管理。

My quick answer is: Stay with MS SQL Server. Go to Oracle only, if you have really GOOD TECHNICAL reason, or if you are planning really an ENORMOUS database, and if you have enough staff to handle all thge administration.

的主要的原因是，SQL Server的是更容易维护;它也大大集成到微软环境。

The main reason is that SQL Server is much easier to maintain; and it also integrates greatly into the Microsoft environment.

甲骨文，相比之下，有一个陡峭的学习曲线。甲骨文的处理更加手动，然后MS SQL服务器。嗯，这也是一个很好的事情，因为你在每一个小细节的控制，但同时也意味着你需要学习很多;或者你需要支付专家。而且这还不是那么容易找到的人谁真正知道该怎么办。

Oracle, in contrast, has a steep learning curve. The handling of Oracle is much more "manual" then MS SQL Server. Well, that's also a good thing, because you are in control of every small detail, but it also means that you need to learn a lot; or you need to pay experts. And it is not so easy to find people who really know what to do.

我真的都喜欢的系统，但是对于一个经验法则，我通常建议使用MS SQL Server中。

I really like both Systems, but for a rule of thumb, I normally suggest to use MS SQL Server.

这篇关于我应该考虑从SQL Server迁移到Oracle为我的ASP.NET应用程序？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！