INTRODUCTION Oracle Database Migration Verifier (Database Migration
Verifier) is a migration tool that you use to verify that the schema and table
data migrated successfully. It compares the source database and the migrated
Oracle Database to ensure the structural integrity of the migrated database
objects. This current release supports the verification of migrating Sybase
Adaptive Server 12 or Microsoft SQL Server 2000 to Oracle9i Database Release
2 (9.2.x) and Oracle Database 10g Release 1 (10.1.x). This tool is intended
for application developers that have migrated a third-party or source database
to an Oracle database.
FEATURES Database Migration Verifier has the following
features:
Compares table, index, view, function, stored procedure,
and triggers in the source database with the Oracle Database
Checks that the object exists in both the source and Oracle
database
Checks the order of the table column
Checks that the table column exists and can produce a NULL
value.
Verifies that the stored procedures and functions exist
in the migrated Oracle Database
Verifies the data type, scale, precision, length, and default
for table columns, functions, and stored procedures
Checks the argument order for stored procedures and functions
Performs single row count checks on all user tables to
verify the integrity of the migrated data
Generates a Database Migration Verifier report that summarizes
the results of all verification checks at schema and data level. It provides
information about object type, object name, argument name, and table information.
This enables you to identify the objects that were not migrated successfully.
Uses JDBC to simultaneously connect to your source database
and Oracle Database.
Uses a Java command line interface to enable you to integrate
the tool into an existing test harness.
Supports several verification checks.
REQUIREMENTS Depending on the source database and Oracle Database that
you are verifying, the minimum requirements to run Database Migration Verifier
are as follows:
JDK 1.3.x
Microsoft SQL Server 2000 Driver for JDBC
Sybase jConnect 4.5 for JDBC
Oracle9i Release 2 JDBC Driver
Oracle Database 10g JDBC Driver
For the most up-to-date information, see the Oracle Database
Migration Verifier Web site at the following:
INSTALLING DATABASE MIGRATION VERIFIER You can install Database Migration Verifier on
a Windows or UNIX system. Ensure that you provide information in the property
file to connect to both the source and Oracle databases.
To install Database Migration Verifier, do the following:
____________________________________________________________________________
Note:Although Database Migration
Verifier is available for UNIX and Microsoft Windows, all of the examples in this document are for Microsoft
Windows. ____________________________________________________________________________
1. Download the dmv.zip file from OTN
at the following Web site:
3. From the dmv_install_dir\config directory, open the
properties file provided for your source database.
If your source database is Microsoft
SQL Server 2000, open the dbinfoss2k.prop file.
If your source database is Sybase
Adaptive Server 12, open the dbinfosybase12.prop file.
4. Edit the properties file to connect
to the source and Oracle database. Provide the following information in your
source properties file:
JDBC class path
Source database URL,
user name, and password
Oracle Database URL,
user name, and password
5. Save the properties file.
USING
DATABASE MIGRATION VERIFIER Database Migration Verifier reads the details
of the source and Oracle databases from the properties file to establish a connection
and compare the databases. It then outputs the results of the comparison to
a report. You can specify a report name or use the default provided. To use
Database Migration Verifier, do the following:
The following provides the details for the variables used
in the previous command:
dmv_install_dir
Directory where you installed Database Migration Verifier.
PropertiesFilePath
Directory and file name where the Database Migration Verifier properties file
is located. Two sample properties files,dbinfoss2k.prop and dbinfosybase12.prop,
are provided for you to edit with your environment. These sample files are located
in the dmv_install_dir\config directory.
ReportStorePath
Directory and file name where the report is saved. If you only provide the directory
location, a file, DMVReport.txt, is automatically created.
VIEWING THE DATABASE MIGRATION VERIFIER
REPORT Database Migration Verifier provides you with
a report that summarizes the migrated source database against the Oracle database.
If the information in the source database is not located in the Oracle database,
the Database Migration Verifier report provides you with information to help
track where the failure occurred. It displays the summary of the migrated objects
and those that did not migrate successfully. It also provides detailed information
about the failures. The object type, object name, argument name, and table information
help you establish if the correct data and number of tables are migrated to
Oracle Database. The Database Migration Verifier report is saved to the location
that you specified when starting the tool. It contains the following information:
Displays the number of each object found in the source
database, the number of objects not found in Oracle Database, and the number
of objects that contain one or more differences between the source database
and Oracle Database.
Provides the object type and name for each object that
exist in the source database, but does not exist in Oracle Database.
Provides the object type that failed comparison, object
name that failed, column/argument where it failed, and description of why
the failure occurred.
Provides the number of rows in both the source and Oracle
if there is a difference between the number of rows in a source database and
Oracle database table object.
For more information about the Database Migration Verifier
report, see the product tutorial available from OTN at the following Web site:
Bookmark
