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

Printer friendly
Cite/link
Email
Feedback
Reader Opinion