Embarcadero Releases New Eclipse SQL Development Tool

Following on its recent series of announcements of key hires from the Eclipse community, Embarcadero is debuting its new professional-grade SQL development tool, PowerSQL, today at EclipseCon 2008. PowerSQL dramatically improves productivity for Eclipse application developers charged with SQL development.

"With the growing sophistication of J2EE, Ruby on Rails and other development frameworks increasingly dependent on databases, application developers require more depth in knowledge and tooling for the underlying DBMS technologies," said Greg Keller, vice president of product management, Embarcadero Technologies. "PowerSQL brings developers what they expect in an IDE with tremendous depth equaling hundreds of man-years worth of experience in database SQL parsing, connection, debugging and general optimization to produce high-performance SQL."

Embarcadero PowerSQL, the company's fourth tool built on the Eclipse framework, is a SQL IDE (Integrated Development Environment) that can be installed as a standalone application (Eclipse RCP) or as an Eclipse plug-in. It offers native support for Oracle, Microsoft SQL Server, Sybase and DB2 for LUW, as well as JBDC support for other prominent DBMSs such as MySQL. PowerSQL runs on both Windows and Linux operating systems. Its flexibility and compatibility, in addition to a low price-point, make it a must-have tool for application developers who are increasingly working with databases.

"We are seeing an upsurge in the number of traditional developers who are taking on more database work and using SQL on a somewhat regular basis," said John F. Andrews, president and CEO of Evans Data Corporation. "In fact, according to research we conducted in September 2007, SQL is the second most popular language among Eclipse users, with 64 percent using it at least some of the time."

Features of the new Embarcadero PowerSQL tool include:
• SQL Code Assist ensures 100% object name accuracy, even when not connected to a database, plus real-time SQL syntax validation
• SQL Project Insight provides project-level SQL file cataloging and search features to help streamline project organization and maintenance
• Migration Wizard imports data sources from Eclipse DTP (Data Tools Project) or Quest TOAD
• Data Source Explorer enables users to easily navigate, search, extract DDL, execute commands, and even browse an outline view without opening the SQL file
• Formatting Profiles ensure consistent, quality code layout for easy review and extension. Profiles can be customized and shared.

"Embarcadero continues to deliver on its commitment to Eclipse," said Mike Milinkovich, executive director, Eclipse Foundation. "By bringing new Eclipse-based tools to market like PowerSQL, more developers are able to experience the many benefits offered by Eclipse. Embarcadero is a great example of a company that is providing innovative solutions to the Eclipse community."

Pricing and Availability
Embarcadero PowerSQL is now available in three versions worldwide: Personal, Standard and Professional. North American pricing for Personal Edition begins with annual subscription-based options as low as $8.25 per month per developer. Embarcadero PowerSQL can be purchased online at www.embarcadero.com/store. For more information, visit www.embarcadero.com/products/powersql.

About Embarcadero Technologies
Embarcadero Technologies, Inc. delivers professional grade database tools that companies use to design, develop and manage databases and the data they contain. More than 12,000 customers worldwide and over 90 of the Fortune 100 rely on Embarcadero's cross-platform tools to reduce complexity, improve productivity and strengthen security. The company's flagship database tools include: ER/Studio, DBArtisan, Rapid SQL and Change Manager. Founded in 1993, Embarcadero Technologies is headquartered in San Francisco with offices in Melbourne, Australia, Munich, Germany and Maidenhead, United Kingdom. For more information, visit www.embarcadero.com.

Embarcadero, the Embarcadero Technologies logos and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of Embarcadero Technologies, Inc. All other trademarks are property of their respective owners.

Source: PRWeb

IBM DB2 9 Compression Demo

Learn how DB2 9's data row compression saves up to 80% in disk space.

The new data row compression technology in DB2 9 can save up to 80% savings on disc space and I/O improvements of up to 40%. If the volume of the data you need to manage is exploding, you may want to take a closer look at DB2 9. View the demo!

Request Your Free Demo!

The Key to Optimal Performance of Your DB2 Applications

Jim Wankowski, DB2 technology specialist for Quest Software, has more than 20 years of development and database administration experience with DB2 and is well known in the DB2 community. In this Webcast, he'll discuss the performance gains you can achieve in IBM DB2 LUW using Toad for DB2. You will learn a 3-step, best practices approach to workflow: develop, optimize, and validate.

AquaFold Releases Enterprise Sybase, MS SQL, Oracle, Server Database Administration Tools for Windows, Linux and OSX

AquaFold, Inc. has released Aqua Data Studio 6.5, a powerful upgrade to its already versatile, multi-platform application that provides complete database administration and query tools for Oracle, DB2, Microsoft SQL Server, MySQL, Sybase, Informix, and PostgreSQL on Linux, OSX and Windows. Within this single application, database managers can save time and money in the design, development and maintenance of enterprise relational databases.

Version 6.5 includes new Source Control Support for Subversion and CVS. With Source Control, multiple users can store, check in and update scripts and other files from within Aqua Data Studio, eliminating the need for other versioning software. This will free system memory, and create a more efficient server update process. ADS also now has a SQL Debugger for Sybase and Oracle which allows users to locate and eliminate problems in SQL statements, eliminating the rigorous searching usually required to locate and correct errors in Sybase and Oracle.

One of the most powerful new features added to the Query Analyzer is its Excel supported Grids, Pivot Grids and Graphs/Charts which allow the grouping and summarizing of selected columns and rows of data into reports. Pivot Grids and Graphs display on multi-level split-panes which allow full control over size configurations persisting over multiple runs of the same query in the same query panel. Their configurations are saveable and reloadable into existing pivot tables for quick and efficient access later. The results can be visualized in three dimensional, fully rotatable graphs, and can be exported directly to, and from, Excel.

Version 6.5 includes a complete set of enhancements for Schema, Directory and File difference tools, including Object Permissions, Filtering by File Size, Background Processing, Refresh, Data Compare, Save as HTML, Preview in Browser, Difference Count and, for File Diff, the ability to Drag & Drop files into the tool. There is also a new Results Difference tool which gives users the ability to view differences between two result sets obtained from either the same or two different queries. The Results Difference tool also allows users to view where columns and rows have been added or deleted and where cells have been edited in different result sets.

In addition, there is now support for auto-completion across multiple databases which allows users to complete a table in a database other than the one they are currently working in. Users can now share the autocompletion schema data across different query windows through the new Global Auto Completion Cache which increases speed by minimizing memory consumption. There are a variety of client side command enhancements which are supported by Query Analyzer scripts, and a new Morph to Delimited List which allows users to convert a block of text into a delimited list with the appropriate options for completing a query or other documentation.

Aqua Data Studio 6.5 is available for immediate download at http://www.aquafold.com/downloads.html A complete list of new features and descriptions may be viewed at http://www.aquafold.com/features_6_5.html The cost of a single-user commercial license is $399(USD). Multi-license purchase discounts are also available and can be viewed here http://aquafold.com/licensing.html

About AquaFold, Inc.
AquaFold, Inc. is a provider of software tools for relational databases. More than 300,000 users from over 90 different countries use AquaFold's products to design, develop and administer databases in Oracle and other popular programs. For more information visit http://www.aquafold.com

Source: PRWeb

Minq Software Ships DbVisualizer 6.0

Minq Software today announced the general availability of DbVisualizer 6.0, a world leading, cost effective, cross platform database tool that increases user productivity by providing a single solution to speed development, testing and administration of relational databases. DbVisualizer offers a robust set of features to assist database developers and DBAs perform tasks such as object browsing, creating, running SQL statements and SQL scripts, viewing and editing data. Additionally, this tool includes features such as a the powerful table references graph, query builder, SQL formatter, result set charting and SQL bookmarks feature.

DbVisualizer supports all major commercial databases including Oracle, DB2, Mimer, SQL Server, Sybase ASE, Informix and open source alternatives such as MySQL, PostgreSQL and JavaDB/Derby. DbVisualizer is optimized for the Windows XP, Mac OS X and Linux/UNIX operating systems.

The new release adds the Table Data Navigator which is powerful tool to navigate foreign keys based on data selections. This is useful when browsing normalized tables with keys to other tables, click an entry in one table, choose the link to follow and the target table will be displayed with the matching data. The new Table Editor supports visual creation and editing of table definitions including columns, indexes, primary, foreign keys, constraints and non standard features specifically for the supported databases. The Data Editor is a central feature that has been revised from ground up, and now supports multiple row operations, transaction control, easy copy/paste with the most popular spreadsheet applications, enhanced filtering, sorting and printing. In addition, this new version is optimized for Windows Vista, DB2 version 9, Java 1.6 and comes with an option to install JDBC drivers for MySQL, PostgreSQL, Sybase, SQL Server, DB2, Mimer and JavaDB/Derby.

"The new features and changes are sweeping and I think we've done a great job putting it all together, still keeping the tool focused and consistent", says Roger Bjärevall, product manager for DbVisualizer at Minq Software.

Availability and Pricing
DbVisualizer is available in two editions, DbVisualizer Free and the commercial DbVisualizer Personal edition starting at $149 per user.

For more information, visit http://www.dbvis.com

About Minq Software
Minq Software is a Swedish software company developing, marketing and selling database software, performance assurance and response time monitoring products. Founded in 1998, it has been a successful provider of load testing and database solutions.

Source: PRWeb

First Autonomic DB2 Optimization Tool For IBM System i

Today, Centerfield Technology, Inc. (http://www.centerfieldtechnology.com) announced the development of the first autonomic tool designed to optimize DB2 for i5/OS. AutoDBA, short for the autonomic database assistant component, provides expert DB2 advice and options to automatically implement that advice. The first release will focus on fully optimizing database indices (DDS logical files and SQL indices); with the objective of making SQL and RPG programs that process large amounts of data much more efficient.

"There are literally thousands of pages of DB2 documentation. Within those pages, there are hundreds of best practices for optimizing database tables, indexes, and program access," says Mark Holm, Centerfield Technology's Chief Technology Officer. "AutoDBA is Centerfield's platform for delivering those best practices on a silver platter to shops -- shops without the time or expertise to comb though a mountain of documentation. AutoDBA understands those best practices, gathers the data necessary to identify opportunities, graphically shows prioritized advice, and can optionally implement those changes with very little risk to applications."

The first autonomic tool designed to optimize DB2 for i5/OS

"AutoDBA is next step in the evolution of DB2 tools," says Elvis Budimlic, Centerfield Technology's Development Director. "The need to actively manage application databases has increased quickly in recent years due to the complexity of applications, extensive use of SQL, an explosive growth of database tables, more users, and the consolidation of servers. Unfortunately, most shops do not have extra people or time to understand the raw data available in other tools -- most shops need answers and solutions, not more data."

Designed to meet the strict definition of "autonomics" as defined by IBM, AutoDBA provides granular policy controls, focused data collection, manual or automated actions (automatic actions controlled by IT policies), full audit support, and the capability to "undo" all changes. Packaged as part of Centerfield Technology's HomeRun suite of tools, AutoDBA will be available to existing Centerfield customers by summer 2007.

About Centerfield Technology

For 10 years, Centerfield Technology has created a set of groundbreaking tools that help companies and ISVs more effectively utilize the AS/400, iSeries, and System i5 (System i). Today Centerfield helps clients manage complex databases, SQL-based applications with that tools deliver high performance database access, reduce the time needed to diagnose application issues and control unrestricted access to System i data.

Source: PRWeb