Oracle SQL Developer vs. Microsoft SQL Server

[Oracle SQL Developer is] best suited if your company works with different databases and needs a common SQL editor to manage and query data for its user. Oracle SQL Developer works very well with Oracle but also some other relational databases. If you do lot of querying and import/export in database, then this is tool for you. It's ideal for DBAs as well for data modeling, management, session monitoring, logging, versioning, etc. It’s not ideal for no relational/noSQL or big data. It is not tool for visualization. It’s best suited for querying using SQL. Companies that are looking for free tools that are robust and most useful should definitely look at it.

Incentivized

Microsoft SQL Server is ideal for highly available SQL workloads by using SQL Server Always On availability groups. Microsoft SQL Server might not be appropriate for solutions which require a very low resource footprint, since it requires significant CPU cores and RAM memory as well as high IOPS, always depending on the usage scenario.

Incentivized

• Export SQL results to a spreadsheet. After a query is run, you are able to export the results to a spreadsheet
• Easily preview data columns on an Oracle table or view and the metadata on those columns.
• SQL Editor is color-coded so that you can tell easily what are keywords.
• You can set up SQL code templates to be able to use shortcut keys to format your SQL query easily in a readable format that you prefer.

Incentivized

• Easy to configure and use with Visual Studio and Dot Net
• Easy integration with MSBI to perform data analysis
• Data Security
• Easy to understand and use
• Very easy to export database and tables in the form of SQL query or a script

Incentivized

• Setup can be challenging if your schemas aren't well formed or managed. Also, the ability to model/develop extensions for an existing database solution will depend on how robust the DBA provisioned roles and designed the respective schemas.
• Detailed analysis of models can be clunky for complex relational models.

Incentivized

• The import/export process can be tricky to follow with lots of steps and could be better for importing flat files
• Obtaining help from Microsoft is cumbersome and often other internet sources are better and quicker
• The documentation is not great and again it's generally better to obtain help elsewhere if needed

Incentivized

It allows most users to perform daily activities in a simple way, with no cost since the tool is free.

Incentivized

I think it is unlikely that sql server has disappointed someone, it is likely that someone will come initially discouraged if the needs and problems that occur are very challenging, but definitely have a SQL oriented system means having a solid base to work and on which maintain the their data securely

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

SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.

Incentivized

Its does not have outages.

Incentivized

SSAS data cubes may some time slow down your Excel reports.

Incentivized

Large user community support

Incentivized

We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.

Incentivized

It was good

Incentivized

very hands on and detailed training

Incentivized

Just download and uncompress!

Incentivized

Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.

Incentivized

Oracle SQL Developer is available on multiple platforms, Windows Mac Linux and it's free. SQL Developer is best suited for a big cross functional globally based team. SQL Developer is less resource intensive, compared to other IDEs. SQL Developer has the capability to manage and develop Oracle Database in both on premise and Cloud deployments. SQL Developer can also connect and interact with non oracle database like MS SQL server and MySQL etc.

Incentivized

Microsoft SQL is slower than MySQL and Access but far more feature-rich and reliable. Access is almost obsolete nowadays, so not too many people are considering it, but unless budget or an open-source ethos is a factor, Microsoft SQL is superior in every way. Many commonly used tools, like Crystal Reports, support it.

Incentivized

SQL server does handle growing demands of a mid sized company.

Incentivized

• No impact on the organization's budget as Oracle SQL Developer is free.
• With the increased productivity of our database administrators, they are able to better assist the software developers in prototyping future products.
• Through Oracle SQL Developer, our administrators were able to normalize many of our databases, reducing the amount of redundancy, and hence increasing the performance of our main application.

Incentivized

• Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
• Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
• Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.

Incentivized