Database Migration Utility Instructions
Version 9.31
E14620-07
January 2012
Oracle Application Testing Suite Release 9.31 supports Oracle Database 10g, 11g or XE 10g as the RDBMS for its load testing and test management components.
As of this version of Oracle Application Testing Suite, only Oracle is certified as the RDBMS. Existing users who are using either Microsoft Access or SQL Server databases for the repository will no longer be using Oracle "certified" software. Existing customers who want to migrate their data from the current Oracle Application Testing Suite database systems into Oracle Database 11g can use this Data Migration Utility to migrate data to their Oracle 11g database. This document describes the Data Migration Utility and how to use it.
This topic explains the basic procedure for migrating data from Oracle Test Manager or Oracle Load Testing in MS Access, SQL Server, or Oracle databases to Oracle Database 11g.
Make sure of the following before starting the data migration procedure:
You have Oracle Database 10g, 11g or XE 10g installed and configured on a server.
An Oracle Database for Oracle Test Manager and/or Oracle Load Testing has been created before running the Data Migration Utility.
Use the Oracle Application Testing Suite Database Configuration application to add and configure an Oracle database for Oracle Load Testing and Oracle Test Manager.
To migrate data using the utility:
Select the Data Migration Tool from the Tools sub menu below the Oracle Application Testing Suite start menu.
In the Source Database dialog box, select the product and database type.
Specify the database source information:
For SQL Server databases, specify the Server and Database info and User information.
For MS Access databases, specify the path and file name of the database file.
For Oracle databases, specify the Server, Port, Service Name, and User information.
Click Next.
Specify the database target information:
Server - enter the name of the server on which the Oracle database is installed.
Port - enter the port number for the connection.
Service name - enter the Service name used for the Oracle database.
User information - enter the logon information for accessing the Oracle database.
Select or clear the Create new objects in this schema option.
Click Next.
If necessary confirm, data overwrite.
Wait while the data is migrated. The progress dialog box appears. Click OK when the data migration is complete.
Click OK to close the migration underway message.
Click Done to close the Data Migration utility.
Click OK to confirm closing the utility.
If you need to migrate data from another database, restart the utility and repeat the steps to specify the source and target database information.
This dialog box lets you specify the details for the database to migrate to an Oracle database. You specify which product database to migrate and the details for the specific type of database.
Product - select which product database to migrate.
Oracle Test Manager - select this option to migrate data from the Oracle Test Manager database.
Oracle Load Testing - select this option to migrate data from the Oracle Load Testing database.
Configuration schema - select this option to migrate data from the Oracle Application Testing Suite configuration data database.
Database type - select which type of database to migrate.
SQL Server - select this option to migrate data from an SQL Server database.
MS Access - select this option to migrate data from a Microsoft Access database.
Oracle - select this option to migrate data from a Oracle database.
Database info - specify the source information for the type of database to migrate. The dialog box changes based on which database type is selected.
The Source Database dialog box requires the following for MS Access databases:
Database file path - enter the location of the existing database file. Click Browse to display the Open dialog box for locating the database. For Oracle Application Testing Suite MS Access databases use <installdir>\OTM\Files\tm.mdb for Oracle Test Manager databases and <installdir>\OFT\Reporter\RSWReport.mdb for Oracle Load Testing databases.
Authentication DB path - enter the location of the existing authentication database for Oracle Load Testing. Click Browse to display the Open dialog box for locating the database. For Oracle Application Testing Suite MS Access and SQL server databases use <installdir>\EmpAppServer\Data\oldinstall.mdb.
The Source Database dialog box requires the following for SQL Server databases:
Server - enter the SQL server name.
Database - enter the name of the database used for the ODBC connection.
User information - enter the logon information for accessing the SQL database.
Use following user information - select this option to enter logon information.
Username - enter the username.
Password - enter the password.
Use NT Authentication - select this option to use the NT logon.
The Source Database dialog box requires the following for Oracle databases:
Server - enter the Oracle database server name.
Port - enter the port number.
Service Name - enter the Service Name of the Oracle database.
Username - enter the username.
Password - enter the password.
The Target Database dialog box lets you specify the details of the Oracle database into which to migrate the MS Access or SQL server databased data. You specify the information for the target database.
Database info - specify the information for the database into which to migrate the data.
The Target Database dialog box requires the following for Oracle databases:
Server - enter the name of the server on which the Oracle database is installed.
Port - enter the port number for the connection.
Service name - enter the name of the database System ID (SID) or service used for the Oracle database.
User information - enter the logon information for accessing the Oracle database.
Using existing user - when selected, an exiting user logon credentials are used. Specify the Username and Password logon credentials.
Create new user - when selected, an a new user is created in the database using the specified logon credentials. Specify the System user and Password and the new user Username and Password logon credentials.
System user - enter the System username to use to logon to the database.
Password - enter the System user password.
Username - enter the username.
Password - enter the password.
Tablespace - enter the name of the table space where the new user will be created. The default is USERS.
Options - specify the overwrite option:
Before migrating data, drop tables in this schema and create new tables - when selected the data migration will create new objects in the database. When cleared, the data migration will ask to confirm if data contained in the target database will be overwritten.
The Results dialog box shows the progress and results of the data migration. The results report starts with the migration information followed by objects being migrated with a description of the action. The following is an sample of the results report:
Oracle Application Testing Suite - Data Migration Product :Oracle Test Manager Source Database :Access Database Name :C:\OracleATS\OTM\Files\tm.mdb User : Target Database :Oracle Server Name :hydra2 Service Name :ORCL User :dbadmin Object Name Description "TESTTYPEID_TRG" Trigger Disabled "TESTCASEACTIVITYID_TRG" Trigger Disabled [...] _System_NodeStatus 1 rows copied _System_PositionIssue 12 rows copied [...] "TO_PROJECT_PROJECTID" Reset value to 19 "TESTTYPEID_SEQ" Reset value to 9 [...] "ISSUESTATUSTYPEID_TRG" Trigger Enabled "REQUIREMENTSTATUSTYPEID_TRG" Trigger Enabled
A message box appears indicating the data migration is in progress. Another message box appears when the data migration is complete. Wait until the data migration finishes before closing the message boxes and Data Migration Utility.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle Application Testing Suite Database Migration Utility Instructions Version 9.31
E14620-07
Copyright © 2009, 2012, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.