Categories
Thoughts

Free Oracle Database 10g

Link – Oracle Database 10g Express Edition Downloads Beta

I don’t think this is going to be much of a threat to MySQL or PostgreSQL users. What Oracle should have done is offer the depreciated 8i Enterprise Edition instead of dumbing down 10g. Basically this is a ploy to get companies hooked on Oracle and then require companies to upgrade to 10g Enterprise Edition when their applications require it. Don’t get too excited about installing ArcSDE with it as the limitations of Express Edition should make it practically unusable. Standard Edition 10g is still a better choice and at about $149 per user, not that expensive.

I still think ESRI should be looking at a version of ArcSDE that works with PostgreSQL but maybe that time is soon.

Categories
Thoughts

Oracle Developer Tools for Visual Studio .NET Released

How cool is this? Oracle has released tools for Visual Studio .NET 2003 to provide integrated support for creating .NET applications that access Oracle databases. Rather than use the weird, non-standard Oracle Java based tools or command line, you can now use the Oracle explorer to browse and alster the schema right from inside Visual Studio. We use Oracle for most of our database applications and better .NET IDE integration was always on our wish list.

  • Oracle Explorer – Browse and alter the Oracle schema via a tree control
  • Designers and Wizards – e.g. Table Designer – makes database tasks easy
  • Automatic Code Generation – Drag and drop to create working code
  • PL/SQL Editor – Edit stored procedures and functions in an integrated Visual Studio .NET environment
  • Stored Procedure Testing – Run stored procedures and functions
  • Oracle Data Window – View and edit your Oracle data
  • SQL Query Window – Execute any ad-hoc SQL statement or script
  • Integrated Help System – SQL, PL/SQL and Error Reference Manuals

Oracle Developer Tools for Visual Studio .NET