Oracle sql developer migration tool4/5/2023 Īutomatic generation of test suites In database migrations involving a large number of business logic implementations in stored programs, it is a big challenge to test all the migrated procedures for accuracy to ensure correct data manipulation and retrieval as well as code-path integrity.Currently, support for Oracle databases is limited by the tools and technologies available and not much choice is available for customers. These technologies can be a great option, especially for large corporations that have dozens or hundreds of applications and databases that need to be migrated, as they can avoid the migration and porting of each application to make it compatible with the Oracle database. Emulation technologies can reduce the need for changes to application programs (especially client/server applications), which otherwise is a significant task in most database migration projects. Įmulation technologies As we discussed in the “Migration Options and Solutions” section in Chapter 7, use of emulation technologies can be an effective way to facilitate a migration effort in terms of porting and migrating applications to an Oracle database.System integrators and customers can easily extend the capabilities of the SQL Developer application migration tool by building rules for converting non-Oracle database SQL statements to Oracle. Oracle SQL Developer 3.0 has some capabilities in this area that currently support the scanning of Sybase CT-Lib/DB-Lib applications, and it has an extensible framework to add support for more databases and languages. Tool-based application code remediation The availability of tools that can migrate source database platform-specific code such as embedded SQL statements, database APIs, and error codes, and that can convert programs written to leverage call-level interfaces for specific databases to target database platforms, can make application migration and porting a lot easier. This is certainly not a new concept, as Java application servers from different vendors incorporate similar functionality, making it easier to deploy Java applications on any standards-compliant application server. Similarly, if all databases were to offer similar functionality and support for general syntax in their procedural language extensions to SQL, such as PL/SQL in Oracle and T-SQL in Sybase/SQL Server, migration from one platform to another would be easier. The wider the differences are among databases in terms of core features and functionalities, the more complex the database migration task will be (e.g., all relational databases follow the same object naming standards and a standard set of data types to manage various types of data).
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |