CODEWITHSUNDEEP
sqlsql-serveroracle-database
Since_2008
Since_2008

Reputation: 2341

Oracle SQL Developer vs SQL Server Management Studio

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?

Thanks!

Upvotes: 5

Views: 19945

Answers (1)

mrjoltcola
mrjoltcola

Reputation: 20842

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

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.

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.

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).

Upvotes: 6

Related Questions