Beset by customer defections to Microsoft and open-source vendors such as MySQL AB, Oracle is making a bid to win back users by enhancing its free tools for migrating data and applications from non-Oracle to Oracle systems.
The software maker this week announced the release of SQL Developer 1.1. This latest version of the free database development tool allows users to browse and manage three non-Oracle databases: Microsoft Access, MySQL and SQL Server.
Oracle is also integrating its Migration Workbench software with SQL Developer. When released later this year, that offering will provide a single tool allowing users to both manage non-Oracle databases as well as import data from them, according to Mike Hichwa, vice president of software development at Oracle.
"It makes perfect sense to combine the two. After all, why would you need two PL/SQL editors?" Hichwa said.
Since its initial release last March, SQL Developer has been downloaded 394,000 times, according to Sue Harper, an Oracle product manager, making it the third-most-downloaded application from Oracle.com.
With its graphical user interface and its ability to browse database objects, run SQL statements and scripts, edit and debug PL/SQL statements and run reports, SQL Developer is ostensibly targeted against Quest Software Inc.'s popular TOAD database administration and development tool, said Donald Burleson, an Oracle consultant and author in Kittrell, N.C.
In fact, SQL Developer, Migration Workbench and a third application migration tool called Apex all form a key part of Oracle's effort to target smaller organizations by offering ease of use and convenience.
"Oracle knows that it's the application selection that drives the choice of database," Burleson said. "Extending the SQL Developer browser [to non-Oracle databases] is not a huge technical achievement, [but] it lays the foundation for migrating entire applications to Oracle by replacing foreign procedural code with Apex and PL/SQL, and using fusion middleware to allow existing applications to use Oracle as their back-end database."
Though still the dominant database vendor, Oracle has found the strategy of touting its software's best-of-breed features obsolete in the face of cheaper, easier-to-use alternatives such as Microsoft's SQL Server or open-source databases like MySQL and EnterpriseDB.
"Oracle simply cannot ignore heterogeneous DBMS environments that most customers have; therefore, the ability of SQL Developer tool to access other databases is critical," said Noel Yuhanna, an analyst at Forrester Research Inc. "We are already seeing that many customers are migrating or looking to migrate from Oracle to SQL Server, but only a few are looking at the other way."
Indeed, Yuhanna said he sees Microsoft as such a threat that it could "overtake Oracle as the No. 1 DBMS company in four to five years if Oracle does not take stronger measures."
Oracle acknowledged that it still has a ways to go. SQL Developer's ability to manage non-Oracle databases remains rudimentary, said Hichwa. And though Migration Workbench has been around since 1998 and can cleanly import table data from non-Oracle databases, it has a far harder time debugging non-Oracle database code such as stored procedures or triggers, he said.
The integrated version due out later this year will improve upon that, and on its ability to tune SQL statements, Hichwa said. It will ship with the next version of Oracle's flagship database, 11g, which is expected to be unveiled at the company's OpenWorld show in October.
- +
Strategies for Dealing With IT Complexity 24/12/2007 10:30:47
Every innovation, every business process improvement, comes with an IT complexity tax that must be paid by CIOs in time, money and sweat. Here are strategies to mitigate the increasing complexity of IT as it enables new business.Every innovation, every business process improvement, comes with an IT complexity tax that must be paid by CIOs in time, money and sweat. Here are strategies to mitigate the increasing complexity of IT as it enables new business.
Read up on the latest ideas and technologies from companies that sell hardware, software and services. Refresh your AUP: Top tips to ensure your acceptable use policy is fit for purpose
Solve Exchange Mailbox Storage Issues Once and for All
Everything you need to know about email and web security (but were afraid to ask)
Email Archiving Implementation: Five Costly Mistakes to Avoid
Discover the advantages of an open architecture multi-vendor network solution
Know thy self: Reduce costs, secure data and ensure compliance with identity management
Wireless LANs: Is my enterprise at risk?
Cutting printer costs
Zones provide focussed content from Computerworld and leading technology partners.Discover how SOA can create smarter outcomes for your business.
Attend and learn:
- How SOA is helping leading companies to become more agile
- Where you should be applying SOA processes in your company
- The top SOA implementation mistakes to avoid
Click here for more information.
- +
Computerworld Live Podcast #97: The Future of Enterprise Networking 25/07/2008 09:45:36
This week CW Live chats with Mark Thompson, global sales and marketing manager for HP ProCurve, on the future of the enterprise networking. Mark discusses the trends we can expect to see in the near future and how the right infrastructure can ensure your enterprise network is secure. - +
Computerworld Live Podcast #96: Security at the Edge 11/06/2008 09:22:22
CW Live speaks with Amol Mitra, HP ProCurve Director of Marketing for Asia Pacific and Japan. Today's topic: how enterprises are starting to shift away from simply controlling security via server logins, firewalls and moving to more adaptive security frameworks. - +
Data Management Edition #10: Multi-Petascale Systems 02/05/2008 09:12:33
This week we look at sustainability and the development of multicore technologies to build multi-petascale systems. - +
IT Security Edition #11: How to poison the Storm botnet 01/05/2008 08:51:55
This week CW Live presents a case study on how to poison the notorious Storm botnet . Plus we take a look at Cisco's plans for Ironport. - +
IT Security Edition #10: Cyber-battles fought and won 24/04/2008 11:09:47
Vendors bow to end user pressure to improve product security, and we take a look at the latest concepts shaping the cyber-battlefield of the future.
Vignette Announces 2008 Excellence Awards 2008-11-21 10:50:00+11
PGP and Ponemon Institute Unveil Inaugural Australian Data Breach Study 2008 2008-11-20 17:34:00+11
Symantec Cloud Services Transform Data Centre Operations Through Proactive Management 2008-11-20 12:06:00+11
Verizon Business Offers Tips to Building a Successful Unified Communications and Collaboration Plan 2008-11-20 12:04:00+11
AARNet Brings 4K Digital Cinema to Australia: First 4K HD Video Signal delivered into Australia by AARNet 2008-11-20 12:02:00+11
Delivering the Power of Choice with Microsoft Dynamics CRM
Join Ed Thompson, Research VP, featured analyst firm, Gartner, Inc., and Brad Wilson, General Manager CRM Microsoft Dynamics, for a new webcast, Delivering the Power of Choice with Microsoft Dynamics CRM, available now. Our panel will break down the best practices for getting the most out of CRM and you'll learn key recommendations you can implement in your organization. Additionally, you'll also hear Microsoft's vision for CRM.









