Sunday | 23 November, 2008
Oracle enhances free migration tools
Bid to win back users
Eric Lai 10/01/2007 11:37:45

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.

Computerworld Buyer's Guide - Vendors Matched to this Article
Computerworld Buyer's Guide - Vendors Matched to this Article
Related Features
  • +

    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.
Additional Resources
Executive Guides
Whitepapers
Zones
Zone logoZones provide focussed content from Computerworld and leading technology partners.
Newsletter Subscription
Sign up for our Computerworld newsletters!
RSS Feeds
Market Place

 

Smart SOA World Tour

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.
Whitepaper

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.

Enterprise IT Buyer's Guide
Find Technology Vendors Fast
 
Find vendors by name | Find by category
Sponsored Links