Deliver Your News to the World

Oracle(r) SQL Developer Migration Workbench Eases Move to Oracle Database 11g


Oracle today announced the general availability of Oracle(r) SQL Developer Release 1.2 which features new capabilities to ease the migration and consolidation of third-party databases onto Oracle Database 11g. Oracle SQL Developer is Oracle’s free database development tool that helps users simplify development cycles and improve productivity of creating and debugging SQL and PL/SQL code and now migrate databases to Oracle.
“Since introducing Oracle SQL Developer, we’ve been focused on expanding the capabilities of the product to meet the needs of the developer community,” said Michael Hichwa, vice president of Software Development, Oracle. “With Oracle SQL Developer Release 1.2, we’re offering a single tool to enable developers to browse and migrate third-party data to an Oracle Database seamlessly, cost-effectively and with minimal risk. This capability greatly simplifies the process of moving data, tables and stored programs from non-Oracle to Oracle Databases to help ensure a smooth migration.”

Oracle SQL Developer Migration Workbench Automates Move to Oracle Database
Oracle has long offered a standalone, migration workbench tool to assist database developers with the migration of non-Oracle databases to Oracle Databases. Oracle SQL Developer Release 1.2 incorporates and integrates a more powerful migration workbench tool � Oracle SQL Developer Migration Workbench. The Oracle SQL Developer Migration Workbench offers database developers a single tool and environment with which to browse third-party data, migrate database objects and data and browse the newly migrated database helping users to reduce time, costs and risks related to moving third-party databases to Oracle.

Oracle SQL Developer Migration Workbench offers a wide spectrum of database migration capabilities. It enables users to migrate a single table or several databases. Users can do a migration while connected to a database or they can generate scripts to use as part of the project and modify the scripts with Oracle SQL Developer’s SQL and PL/SQL creation and de-bugging tools. Oracle SQL Developer Migration Workbench features new parsers that recognize 100 percent of T-SQL syntax as well as single statement translators that allow users to paste any kind of T-SQL into an editor and translate it instantly into PL/SQL.

The Oracle SQL Developer Migration Workbench offers database developers two options for performing migrations. Users may conduct migrations in a single step with a wizard utility delivered by the tool or they may break down the migration process into steps to allow them to make changes throughout the various stages of the migration as necessary. The tool allows users to migrate the following third-party databases to Oracle:
* Microsoft SQL Server (versions 7, 2000 and 2005);
* Microsoft Access (versions 97, 2000, 2002 and 2003); and,
* MySQL (versions 3.0, 4.0 and 5.0).

ABB Automation Printing Saves Time with Oracle SQL Developer Migration Workbench
ABB, one of the world’s leading engineering firms, is relying on Oracle SQL Developer Migration Workbench for its SQL Server to Oracle Database migrations. ABB’s Automation Printing solutions have proven their value in many printing installations around the world and offer substantial advantages regarding asset and value chain optimization. ABB’s scope of operation ranges from the page planning, the digital workflow, the roll supply, the press automation up to the total planning and tracking of the entire production chain. ABB Automation Printing has utilized new migration workbench capabilities of Oracle SQL Developer Release 1.2.

“Oracle SQL Developer Migration Workbench is the perfect IDE for our SQL Server 2005 to Oracle migration process,” said Karl Doerig, Architect, ABB Automation Printing. “The new migration workbench allows us to migrate a SQL Server 2005 Database schema with some 350 tables and around 1,000 stored procedures in less than two hours and with very little manual editing. Before, it took us around two days to do the same task, and we had two pages of instructions for manually altering the output.”

Availability and Pricing
The production version of Oracle SQL Developer is available for download from the Oracle Technology Network at: .


This news content was configured by WebWire editorial staff. Linking is permitted.

News Release Distribution and Press Release Distribution Services Provided by WebWire.