Oracle on Monday is shipping an upgrade to its free database development tool, adding a number of enhancements, including the capability to access competing databases such as Microsoft Access and MySQL.
Oracle SQL Developer Release 1.1 provides a graphical front end to build database applications, eliminating the need for a third-party tool or command-line interactions to build applications or perform functions such as adding tables and objects to a database.
“It makes users that work with the database very productive very quickly,” said Sue Harper, Oracle senior principal product manager. The first version of the product, released in March 2006, was downloaded 394,000 times, she said.
A key improvement in Version 1.1 is its capability to connect to non-Oracle databases, including Microsoft SQL Server, MySQL, and Microsoft Access. This improvement is a precursor to a feature called Migration Workbench Extension, planned for Oracle SQL Developer 2.0 later this year and intended to help migrate data off other databases and onto Oracle.
“Now we have one tool that can access both of the databases that we use here,” said SQL Developer user Dominic Delmolino, senior director of database engineering at Network Solutions. “The developers really like having just one interface.”
Network Solutions is using Oracle and MySQL and has selectively migrated some MySQL data to Oracle, Delmolino said.
A single pivot view capability in Version 1.1 allows users to more closely examine a single record, such as a grid of data in an Excel spreadsheet that is being stored in the database. A duplicate record function for the product’s grid view also is featured, providing the capability to update only specific changes rather than an entire record.
Users with Version 1.1 can create reports that feature graphs. “That’s very powerful because people can visually see the reports,” Harper said.
Also featured in SQL Developer 1.1 are new filtering capabilities in the product’s object browser. Productivity also is improved for creating and debugging SQL and PL/SQL code. Oracle SQL Developer 1.1 is available at the Oracle Technology Network. Oracle also is announcing the SQL Developer Exchange site, which lets users request feature enhancements and share code.
This whitepaper explains the terminology and concepts behind Data Replication technologies and establishes some sizing rules through worked examples. Learn the new paradigm in disaster tolerance—protect data anywhere.
Download now »
Server virtualization is a popular option for dealing with mounting datacenter costs. Another equally promising approach is the use of an Application Delivery Controller. Citrix NetScaler provides a low-cost way for organizations to reduce their server count and accrue cost savings from a reduction in space, cooling, power and personnel.
Download now »
The emergence of WLANs has created a new breed of security threats to enterprise networks.
Included in HP ProCurve WLAN solutions is security technology that alleviates threats from WLANs through:
* Monitoring wireless activity inside and out of the enterprise
* Classifying WLAN transmissions into harmful and harmless
* Preventing transmissions that pose a security threat to the enterprise network
* Locating participating devices for physical remediation
Effectively address data protection challenges, implementing solutions that help store and protect business–critical data while cutting costs and improving efficiency and reliability.
Download now »
Sign up to receive InfoWorld Resource Alerts
Recommend This
