Oracle Database Migration Verifier

Oracle Database Migration Verifier (DMV) is a new tool to assist with migrating your Microsoft SQL Server or Sybase Adaptive Server database to the Oracle platform. Database Migration Verifier analyzes your source database and compares it against your Oracle Database, to validate the structural and data integrity of your migrated Oracle Database. The tool produces a detailed report summarizing the test outputs for schema and data verification checks, to enable you to verify the schema and data in your migrated databases.

Interested in getting access to a pool of technical expertise on how to successfully migrate? Visit our new Oracle Migration Knowledge Base to gain access to technical migration articles provided by Oracle technical field staff.

Core Features

Compares schema and data between source and migrated Oracle database
Supports verification of tables, indexes, function, stored procedures, and triggers, and view objects
Validates data in migrated Oracle database against source database
Generates a Verification Report of schema and data verification failures summarized by object name and type
Provides command line tool interface, allowing tool to be seamlessly integrated into existing testing processes
Provides portable Java application implementation allowing tool to be easily moved between Windows and UNIX environments
Provides support for Microsoft SQL Server 2000 and Sybase Adaptive Server 12 source databases





 

Supported Databases

Third-Party Database
Supported Version
Required JDK/JDBC Drivers
Microsoft SQL Server
2000

Sybase Adaptive Server

12
Source Database
Supported Version
 

Oracle

9.2.X

  10g

NOTE: A minimum of JDK 1.3 is required to run Oracle Database Migration Verifier tool. Oracle9i Release 2 includes JDK 1.3. Oracle10g includes JDK 1.4.1. They are located in a jdk directory in your installed ORACLE_HOME. Alternately, download the JDK from the Sun Web site.

 

Features

Feature Support Verification Check SQL Server 2000 Sybase 12
Tables
Table and Table Column Existence
Table Column Name
Table Column Order
Table Column Datatype
Table Column Nullability
Table Column Attributes
Table Column Defaults
Views
View Existence
View Column Name
View Column Order
View Column Attributes
Indexes
Index Existence
Index Column Order
Functions
Function and Function Argument Existence
Function Argument Order
Function Argument Datatypes
Function Argument Attributes
N/A
N/A
N/A
N/A
Stored Procedures
Procedure and Procedure Argument Existence
Procedure Argument Order
Procedure Argument Datatypes
Procedure Argument Attributes
Triggers
Trigger Existence
Data
Single Rowcount Check

Technical Papers
Oracle Migration Workbench Data Sheet
Oracle Migration Workbench White Paper
Discussion Forums
Oracle Migration Workbench

 
Left Curve
Downloads
Right Curve
·
·
 ·
 ·
·
 

Left Curve
Tutorials
Right Curve
 ·

Left Curve
Useful Documents
Right Curve
 ·
 ·
 ·
 ·
 ·
 ·

Left Curve
Feedback and Support
Right Curve
 ·
·

Left Curve
Related Links
Right Curve
 ·
 ·
 ·
 ·
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy