Printer Friendly
The Free Library
14,506,237 articles and books
Member login
User name  
Password 
 
Join us Forgot password?

ArtinSoft Announces Automated Solutions for Migrating from Oracle to Microsoft SQL Server; New Products and Services Accelerate Database Conversions.


HERNDON, Va. -- ArtinSoft, the innovative provider of Freedom(R) automated software transformation technology and services, today announced two new products to ease migrations from the Oracle(R) database to Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System. . The company also introduced new services offerings that combine these products with established best practices to deliver low-risk turnkey database conversion projects.

New Automated Migration Products

The PL/SQL (Procedural Language/SQL) A programming language from Oracle that is used to write triggers and stored procedures that are executed by the Oracle DBMS. It is also used to add additional processing (sorting and other manipulation) of the data that has been returned by  Assessment Tool is a free product that enables organizations to plan a faster migration with less risk. It identifies potential challenges and provides data that helps in estimating the effort required. The wizard-based tool connects to the Oracle database and generates a series of customizable XML XML
 in full Extensible Markup Language.

Markup language developed to be a simplified and more structural version of SGML. It incorporates features of HTML (e.g., hypertext linking), but is designed to overcome some of HTML's limitations.
 reports that inventory and analyze the business logic embedded within PL/SQL stored procedures, functions, packages and triggers. Other reports categorize these objects by complexity to help optimize the order in which they are migrated to SQL Server An earlier relational DBMS from Sybase and from Microsoft. Sybase introduced SQL Server in 1988 for various Unix versions. In that same year, with help from IBM, Sybase created an OS/2 version that Microsoft licensed and branded as Microsoft SQL Server. .

ArtinSoft's new Freedom(R) Migration Studio for PL/SQL to T-SQL T-SQL Transact - Structured Query Language (Microsoft SQL Server)  provides an interactive development environment to extract the PL/SQL code from the Oracle database and automatically convert it to Transact-SQL (T-SQL) for SQL Server. The Migration Studio features an intuitive graphical interface See GUI.  for high productivity throughout the migration process, including the ability to edit the generated T-SQL code as necessary and upload it directly into SQL Server for testing. The generated code is clear and well-formatted, and existing user comments are preserved for readability and easy maintenance.

The Migration Studio automatically converts over 200 PL/SQL features, including:

--Stored Procedures and Functions

--Triggers

--Cursors

--Packages

--Flow Control Statements

--SQL Statements

--Sequences

--Transactions

--Error Handling (Exceptions)

--Built-in Packages and Functions

The PL/SQL Migration Studio is based on ArtinSoft's proven AI-based Freedom technology, which delivers automated migration rates of 85-95% with even complex PL/SQL code.

Users See High Returns

Since rewriting embedded PL/SQL business logic into T-SQL is usually the most difficult part of an Oracle migration, the PL/SQL Migration Studio delivers huge productivity gains.

SuPen, the government agency that manages Costa Rican pension funds, is a beta user of the Migration Studio. Oscar Hidalgo Hidalgo, state, Mexico
Hidalgo thäl`gō), state (1990 pop. 1,888,366), 8,058 sq mi (20,870 sq km), central Mexico. Pachuca de Soto is the capital.
, SuPen's DBA, confirmed, "The Freedom Migration Studio converted about 95% of our PL/SQL code, identified all the other code that was not automatically migrated, and produced legible leg·i·ble  
adj.
1. Possible to read or decipher: legible handwriting.

2. Plainly discernible; apparent: legible weaknesses in character and disposition.
 and maintainable T-SQL code."

Another beta customer, a $60M healthcare software organization using the PL/SQL Migration Studio to convert its Oracle-based product to SQL Server, stated: "Of the products that we tested, ArtinSoft's Migration Studio was the clear winner due to a more complete conversion of PL/SQL (especially function calls within stored procedures) and a superior user interface. We feel that the Migration Studio does a more thorough job and produces more sustainable code upon which we can continue to build and improve our product." That organization expects to complete its entire migration with the help of the PL/SQL Migration Studio in only 1/3 of the time it estimated for a manual conversion using information provided by the PL/SQL Assessment Tool.

"SQL Server continues to be the fastest growing database in the industry with its comprehensive data management and business intelligence capabilities. Its proven lower cost of ownership, strong business value proposition, and superior performance are attracting new customers that have traditionally used other platforms," said Joe Yong, SQL Server Technical Product Manager for Microsoft Corp. "However, uncertainty around the costs of database migrations made many customers hesitant to switch to SQL Server. By working with great partners like ArtinSoft, some of that uncertainty can be eliminated. Customers now have a set of tools that can accelerate the process and significantly reduce costs, making migrations from Oracle to SQL Server even more attractive."

New Oracle to SQL Server Migration Services

With over ten years of experience in delivering turnkey migration projects, ArtinSoft also announced the availability of new consulting service Noun 1. consulting service - service provided by a professional advisor (e.g., a lawyer or doctor or CPA etc.)
service - work done by one person or group that benefits another; "budget separately for goods and services"
 programs for migration from the Oracle RDBMS (Relational DataBase Management System) See relational database and DBMS.

RDBMS - relational database
 to SQL Server. The company's proven Ready-Set-Go(TM) methodology and best practices are combined with its new automated PL/SQL migration products to deliver turnkey fixed-price customer migration projects with significantly lower cost, timeframe and risk.

Pricing and Availability

The PL/SQL Assessment Tool is free of charge, and can be downloaded from ArtinSoft's website. A pre-release version of the Freedom Migration Studio for PL/SQL to T-SQL is also available now, with general release planned by the end of 2004. The Migration Studio is licensed on a per-application basis, and pricing varies depending on the amount of PL/SQL code to be converted.

About ArtinSoft

Founded in 1993, privately-held ArtinSoft is the industry leader in automated software migration driven by advanced artificial intelligence technologies. ArtinSoft's products and services help customers worldwide to leverage and protect their investment in current applications as they evolve to new platforms such as Microsoft .NET See .NET. . Microsoft itself turned to ArtinSoft to create the migration solutions supplied within its Visual Studio product, including the Visual Basic Upgrade Wizard, the Java Language Conversion Assistant (JLCA (Java Language Conversion Assistant) Software from Microsoft that converts Java programs to C#. JLCA is used with Visual Studio .NET. See C#. ), the ASP Migration Assistant and the PHP (PHP Hypertext Preprocessor) A scripting language used to create dynamic Web pages. With syntax from C, Java and Perl, PHP code is embedded within HTML pages for server side execution.  Migration Assistant.

ArtinSoft's leadership in software transformation technology and its broad experience as a provider of migration services led Microsoft to name ArtinSoft as its "preferred supplier of worldwide upgrade services for Microsoft customers".

ArtinSoft's U.S. headquarters is located in Herndon, Virginia Herndon is a town in Fairfax County, Virginia, United States. The population was 21,655 at the 2000 census, which makes it the largest of three towns in the county.[1] History . R&D and Latin American sales operations are based in San Jose San Jose, city, United States
San Jose (sănəzā`, săn hōzā`), city (1990 pop. 782,248), seat of Santa Clara co., W central Calif.; founded 1777, inc. 1850.
, Costa Rica Costa Rica (kŏs`tə rē`kə), officially Republic of Costa Rica, republic (2005 est. pop. 4,016,000), 19,575 sq mi (50,700 sq km), Central America. . For more information, visit our website at www.artinsoft.com.

ArtinSoft and Freedom are registered trademarks, and Ready-Set-Go is a trademark of ArtinSoft Corp. All other product or service names mentioned herein are the trademarks of their respective owners.
COPYRIGHT 2004 Business Wire
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2004, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

 Reader Opinion

Title:

Comment:



 

Article Details
Printer friendly Cite/link Email Feedback
Publication:Business Wire
Geographic Code:1USA
Date:Dec 3, 2004
Words:926
Previous Article:Raymond Tomlinson of BBN Technologies, Co-Designer of the First Email System, Receives IEEE Internet Award.
Next Article:Shorts International to Exclusively Distribute Leading American Short Film Catalogue.
Topics:



Related Articles
SYMANTEC DEBUTS VISUALCAFE WITH POINTBASE 100% PURE JAVA.(Company Business and Marketing)
ManTech Systems Solutions Corporation Licenses Database Conversion Tool to IBM; Reach of SQL Conversion Workbench Extended to IBM's Customer Base.
ManTech Systems Solutions Corporation Supports Customers Migrating to IBM DB2 Universal Database Version 7; New Tools and Services Make Migration...
Bunker Hill Makes Open Source More Accessible.
UNISYS JUMP STARTS ITANIUM 2-BASED SERVER PERFORMANCE BOOST.
SmartDBA System Performance for DB2.(Database & Network News and Products)
ArtinSoft Announces JLCA Companion to Accelerate Migration of Applications from Java to the Microsoft .NET Framework.
AdventNet Forms Alliance with Sybase Middle & Central East and Europe to Enhance Its SwisSQL Database Migration Solutions for Sybase ASE.
Migrating to MySQL: Dmitry Tolpeko.(DATABASE & NETWORK JOURNAL INTELLIGENCE)
Quest Software Wins Record 11 Readers' Choice Awards from SQL Server Magazine; Readers Strongly Endorse the Value of SQL Server Management Products...

Terms of use | Copyright © 2009 Farlex, Inc. | Feedback | For webmasters | Submit articles