Oracle SQL Developer vs. Microsoft Visual Studio vs. Xcode

Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.

It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.

Incentivized

When working with base C# code for desktop and web projects, then Microsoft Visual Studio is ideal as it provides the libraries and interfaces needed to quickly create, test and deploy solutions. It is when slightly more complex scenarios are required that issues can arise. The built-in integration for things like PowerBI Paginated Reports and dashboards is far from ideal.

Incentivized

This is almost not a case of Xcode being the 300-pound gorilla in the space, but of it being essentially the ONLY viable gorilla in the space. There are other text editors, of course, that can be used for coding; and in some cases other IDE's might make sense for a cross-platform development scenario, but since this is Apple's in-house tool, fighting against that flow is just going to be an exercise in frustration. And, if you need help from Developer Support, they are going to be most familiar with Xcode.

Incentivized

• Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
• The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
• DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.

Incentivized

• I like how the tabs and panels are organized; everything is gathered together so you can find what you're looking for quickly.
• If you can't find something, there's a thorough search engine that searches all of Visual Studio's features.
• The Team Foundation Server feature is fantastic since it allows us to easily deploy and roll back changes on the server.

• Debugging
• Profiling
• Great IDE

Incentivized

• Inability to run multiple queries on the same database. You can only run one query on a given database.
• Analytical models created from complex tables isn't accurate, and needs work.
• Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page.

Incentivized

• Would be great if there was a better way to save and restore open tabs.
• The built-in test runner can be improved, for example, by adding the ability to save a set of commonly run tests, etc.
• Better integration for Microsoft SQL server would be great.

Incentivized

• Documentation
• Number of settings can be overwhelming
• Embedded help for settings and configuration
• Templates
• Collaboration
• Managing of credentials (although this has recently gotten better)

Incentivized

We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.

Incentivized

VS is the best and is required for building Microsoft applications. The quality and usefulness of the product far out-weight the licensing costs associated with it.

Incentivized

Oracle SQL Developer is very easy to use and there are a wide range of courses available which can help you get started just within a day. Data can be exported in multiple formats based on user requirements. Organizational data can be stored and management effectively using Oracle SQL Developer. All the data, tables, sequences, indexes can be easily created and updated in Oracle SQL Developer.

Incentivized

I love the overall usability of Microsoft Visual Studio. I’ve been using this IDE for more than 20 years, and I’ve seen it evolve by leaps and bounds. Today, with AI and code-suggestion/completion features, developers no longer need to remember countless libraries, methods, or language syntax, or invest a huge amount of programming effort to complete a project. It truly offers everything a developer needs to program, debug, test, and deploy in a single IDE.

Incentivized

Xcode occasionally exhibits some behaviors that are hard to explain, but are generally cleared by restarting the program. In an application this large and complex, I suppose this is somewhat expected. The sheer vastness of the frameworks collection has to be a huge management issue all by itself. However, those breaks in the flow can have impact on developer productivity.

Incentivized

Since we don't use the cloud based features of Xcode, it is basically available 24/7 for us. We don't need the extended compilation features that are offered in the cloud as our projects to this point have not been that large or complex. We have never seen a wholesale breakdown of Xcode availability at any point in our use of the product.

Incentivized

Every developer wants faster compiles, but that can be achieved by either going to the cloud or by provisioning the local station to a higher powered configuration. My only minor complaint is the amount of local mass storage that Xcode as a system consumes. This makes it interesting to set up a development environment on a midrange laptop, however it is easily managed with external storage at a reasonable price.

Incentivized

Large user community support

Incentivized

There are many resources available supporting Visual Studio IDE. Microsoft whitepapers, forum posts, and online Visual Studio documentation. There are countless demonstration videos available, as well. If users are having issues, they can call Microsoft Support, but depending on the company's agreement with Microsoft, the number of included support calls will vary from organization to organization. I've found that Microsoft support calls can be hit or miss depending on who you get, but they can usually get you with the right support person for your issue.

Incentivized

IT is very complicated to understand all the functions that the environment has if you are not familiar with this type of development environments. It is important to select a good in-person training to achieve to understand all the possibilities and the capacity of the application. In this case, you will be able to develop a lot type of different applications.

Incentivized

If you are not accustomed to develop in this type of development environments it would be complicated to follow all the parts of the course because if the course does not include a great tour with all the concepts to develop you will not have the option to understand all the functions.

Incentivized

Just download and uncompress!

Incentivized

I have started to use Toad for Oracle recently because it is easier to sort and filter results, due to their memory sort feature that puts the results from your query in memory so that you don't have to rerun your query. I have used SQL Developer to easily update records in tables that I need to fix. I haven't found an easy way to do this in Toad other than writing SQL insert statements.

Incentivized

I personally feel Visual Studio IDE has [a] better interface and [is more] user friendly than other IDEs. It has better code maintainability and intellisense. Its inbuilt team foundation server help coders to check on their code then and go. Better nugget package management, quality testing and gives features to extract TRX file as result of testing which includes all the summary of each test case.

Xcode is a much easier to use and full featured IDE than many of the competitors. It also is a way better experience to use. Much better looking in general

Incentivized

Xcode only loses points due to the occasional situation where it manages to somehow tie itself into a knot and starts to exhibit odd symptoms. This is almost always solved by simply saving progress and restarting the environment. Fortunately, that doesn't happen too frequently and is easily repaired while taking a short break to walk around and stretch.

Incentivized

• It gives 100% return on investment as it is free of cost.
• No need to have multiple tools for each database
• Considering the employee training, so one can save money on training, as it is not very hard to use so still savings.

Incentivized

• Using the integration between Visual Studio and our source control service, the cost of re-work and losing code is drastically reduced.
• Paid versions of Visual Studio enable developers to be so much more productive than hacked-together open source solutions that it's hard to imagine developing in Windows without it.
• When combined with support subscriptions and the vast array of free online help options available, Visual Studio saves our developers time by keeping them coding and testing, not wasting their time trying to guess their way out of problems or spend endless hours online hoping to find answers.

Incentivized

• It's helped us gain worldwide distribution of our native iOS app
• It's allowed us to build a high performance experience
• It has allowed us to build stable software by helping us write unit tests

Incentivized