Oracle and Visual Studio 2019... no developer tools yet!
September 18, 2019
Oracle and Visual Studio 2019... no developer tools yet!
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database
Multiple departments use Oracle and different software use connections to multiple databases that are in Oracle. It allows connectivity with all applications and it's useful for all the reporting tools we have. We can keep all our customer data in one central location.
- Oracle allows you to connect to multiple reporting tools.
- Oracle has extensive patches and distributes them in a timely manner when they release them.
- They can handle multiple databases and hold tons of data history.
- It is very reliable and doesn't crash like other products.
- SQL Developer lacks functionality that would be useful, like displaying all records at once when you query
- SQL Developer crashes a lot and it is buggy. We would love to use it more but it is hard to use at times.
- They haven't or don't release Oracle Data tools for Visual Studio 2019. We are almost at the end of the year 2019 and still no data tools yet.
- Connection to .NET is kind of complicated and not very easy as compared to Microsoft SQL Server that allows you to connect easier.
- Oracle, in general, doesn't compare in terms of use with SQL Server. Data takes a little bit longer to get pulled when you create .Net applications.
- Connections have to be opened and closed or else you can end up with multiple connections open. As opposed to SQL Server where it opens the connection and it is closed immediately with very little code.
- Oracle doesn't provide many examples of how Oracle implements and interacts with .NET.
- We don't have to worry much about security because of security encryption.
- It can handle large amounts of data and backups are easy to recover.
- We can keep historical data for a long time and be sure that the data is secure.