Oracle SQL Developer 与 SQL Server Management Studio

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/7108028/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-19 00:15:23  来源:igfitidea点击:

Oracle SQL Developer vs SQL Server Management Studio

sqlsql-serveroracle

提问by Kukoy

I just installed Oracle SQL Developer, and attached it to my SQL Server. I like to expose myself to different environments. I was wondering if anyone knows of any benefits that the Oracle SQL IDE has over the SQL Server IDE. Is there any reason at all why I should keep the Oracle IDE, if the only sever I play with at the moment is SQL Server?

我刚刚安装了 Oracle SQL Developer,并将其附加到我的 SQL Server。我喜欢让自己接触不同的环境。我想知道是否有人知道 Oracle SQL IDE 比 SQL Server IDE 有什么好处。如果我目前唯一使用的服务器是 SQL Server,那么我是否应该保留 Oracle IDE 的任何理由?

Thanks!

谢谢!

采纳答案by codenheim

I cannot think of any advantages or reasons to use Oracle SQL Developer if you only do SQL Server development.

如果您只进行 SQL Server 开发,我想不出使用 Oracle SQL Developer 的任何优势或理由。

At best, you are limiting yourself on the SQL Server features that you cannot access via SQL Developer. Things like backing up your db, attaching, detaching, scripting, user security, etc. Not to mention SQL Server's T-SQL awareness that Oracle will not have.

充其量,您将自己限制在无法通过 SQL Developer 访问的 SQL Server 功能上。诸如备份数据库、附加、分离、脚本编写、用户安全等。更不用说 Oracle 没有的 SQL Server 的 T-SQL 意识了。

Being able to attach Oracle SQL Developer to SQL Server is really meant for people integrating the two. Otherwise, use a SQL Server specific tool.

能够将 Oracle SQL Developer 附加到 SQL Server 确实适用于将两者集成的人。否则,请使用 SQL Server 特定工具。

PS: Consider, a lot of Oracle DBAs and Developers don't use Oracle SQL Developer anyway. If you want to expose yourself to a good tool, try Toad, SQL Navigator or DBArtisan (for Oracle).

PS:考虑一下,很多 Oracle DBA 和开发人员无论如何都不使用 Oracle SQL Developer。如果您想让自己接触到一个好的工具,请尝试使用 Toad、SQL Navigator 或 DBArtisan(适用于 Oracle)。