Oracle Migration Workbench 中的插件应该放到哪个文件夹下？
由于ORACLE的官方网站上无法下载，所以我在非官方网站下了移植平台和插件。我下的是一个压缩包，解压后有两个文件夹“omwb”和“SQLServer2K”，omwb中的应该就是工作平台，SQLServer2K中的就是对SQLServer数据库支持的插件，现在的问题是我不知道该把插件放到哪个文件夹目录中去，我每次运行都提示我没有找到相应的插件。
[解决办法]
唉，好久以前做过sybase到oracle的数据移植，用过这个工具，现在也忘差不多了，给你一些当时OMW相关BBS讨论内容看看先：
sunsanvin:
Posts: 2
From: hyderabad
Registered: 5/24/06
how to work with workbench
Posted: Sep 14, 2006 4:18 AM Reply
hi friends, i 'm very new to migration work bench. i just downloaded the software.
omwb[1].zip file was saved on my desktop.i dont know how to install and how to start with this tool.please provide me your great guidence.
/////////////////////////////////////////////////////////////////////////////////
totierne:
Posts: 182
Registered: 1/12/01
Re: how to work with workbench
Posted: Sep 14, 2006 11:46 AM in response to: sunsanvin Reply
Sunsanvin,
Full details are in the instructions included with the tool when you unzip copy in the plugin and click on omwb.bat
Download the plugin for the database you want to migrate (the plugin is a java jar file containing the compiled java code, we do it this way largely so we can track per database downloads)
unzip the zipped file and place the plugin in the plugins directory.
Sometimes say for mysql or informix a jdbc driver file is required from the vendor, for Microsoft databases this is not required.
double click on omwb.bat to start the program.
assuming you are migrating Microsoft sql server the following outlines the procedure:
1/Say where you want to store the work in progress ( 'repository ') internally or in an oracle database.
2/Put in the details to log in to the sql server database, it will then
3/Extract the structure of the database 'Source Model ' which is viewable in a tree.
4/Create the 'Oracle Model ' which is viewable in a tree.
4/The Oracle database can be created using the oracle model
There are a few options such as offline capture and offline data moving, and creating the script to build the oracle database rather than creating the oracle database directly.
The main issues are:
1/You need sa/dbo access to sql server (or someone to run some selects/scripts for you as sa/dbo).
2/Stored procedure conversion for advanced features is not complete so for example you need to convert sql server sp_ stored procedure calls to the oracle equivalent.
Basically it is easy to start working with the the tool, you may want to start with a smaller project/test database ( 'pubs ') to get familiar with the tool.
Turloch
Oracle Migration Workbench Team
//////////////////////////////////////////////////////////////////////////////////
ddaly:
Posts: 419
From: Dublin, Ireland
Registered: 1/10/01
Re: MS-sql to Oracle 9i Migration
Posted: Jun 2, 2006 8:00 AM in response to: sadique.mohamed Reply
The Workbench uses an underlying repository, so all the choices you make are saved. However the primary usage of the tool, is one off migration, not continous migration. If you want to rerun multiple times, you should probably generate the offline schema and data migration scripts.
Donal
[解决办法]
找了一下，我配置了dbInfoss2k.prop这个配置文件内容如下：
# Oracle Database Migration Verifier Properties File for
# Microsoft SQL Server 2000
# Developers Release 1.0.0
#
# File Name: dbinfoss2k.prop
#
# Update this file to specify the JDBC driver connect URLs for your environment. This is used
# by the Oracle Database Migration Verifier (Database Migration Verifier) to connect to your
# Microsoft SQL Server 2000 database and verify against the Oracle Database.
#
#____________________________________________________________
#Note: Although Database Migration Verifier is available for
#UNIX and Microsoft Windows, all of the examples in
#this document are for Microsoft Windows. For
#Microsoft Windows, use double back slashes (\\) to
#separate paths and a semi-colon (;) to separate
#class paths. For UNIX, use a single forward slash (/)
#to separate paths and a colon (:) to separate class
#paths.
#____________________________________________________________
#
#
# Edit the properties file for your environment. A sample
# Microsoft SQL Server 2000 properties file, dbinfoss2k.prop,
# is located at the following directory:
#
# dmv_install_dir\config
#
# where dmv_install_dir is where you have installed the Oracle Database Migration Verifier
#
#=====================================
# GENERIC JDBC CLASSPATH SETTINGS
#=====================================
#
# Update the JDBC class path with values for the location of the
# Oracle JDBC and Microsoft SQL Server 2000 JDBC drivers.
#
# ORACLE JDBC Drivers
#=======================================================
# For JDK 1.3 (Oracle9i Database Release 2 (9.2.x)), enter the location of the
# classpath for the classes12.jar file. The file is typically
# located in the following directory:
#
# ORACLE_HOME\jdbc\lib
#
# where ORACLE_HOME is the Oracle home directory specified by the
# %ORACLE_HOME% environment variable on Windows or the
# $ORACLE_HOME environment variable on UNIX.
#
# For JDK 1.4 (Oracle Database 10g Release 1 (10.1.x)), enter the location of the classpath
# for the ojdbc14.jar file. The file is typically located in the following directory:
#
# ORACLE_HOME\jdbc\lib
#
# where ORACLE_HOME is the Oracle home directory specified by the
# %ORACLE_HOME% environment variable on Windows or the
# $ORACLE_HOME environment variable on UNIX.
#
# Microsoft SQL Server 2000 JDBC Drivers
#=======================================================
# For Microsoft SQL Server 2000 JDBC drivers, enter the location of the
# msbase.jar, msutil.jar, and mssqlserver.jar files.
# By default, these files are installed into the following location:
#
# C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib
#
# Alternately, you can download the JDBC drivers from Oracle Technology Network
# at the following Web site:
#
# http://otn.oracle.com/tech/migration/dmv
#
# Example of JDBC Classpath
#================================
# JDBC.ClassPath = d:\\oracle\\ora92\\jdbc\\lib\\classes12.jar;
# C:\\Program Files\\Microsoft SQL Server 2000 Driver for JDBC\\lib\\msbase.jar;
# C:\\Program Files\\Microsoft SQL Server 2000 Driver for JDBC\\lib\\msutil.jar;
# C:\\Program Files\\Microsoft SQL Server 2000 Driver for JDBC\\lib\\mssqlserver.jar
#
JDBC.ClassPath = C:\\classes12.jar;C:\\msbase.jar;C:\\msutil.jar;C:\\mssqlserver.jar;
#=======================================================
# Microsoft SQL Server 2000 JDBC CONNECTION SETTINGS
#=======================================================
# Enter the JDBC URL for the Microsoft SQL Server 2000 database.
# You can use a Microsoft SQL Server 2000 JDBC URL similar to the following format:
#
# jdbc:microsoft:sqlserver://yourServerName:PortNumber(default=1433);
# DatabaseName=yourDB;User=yourUser;password=yourPwd;
# SelectMethod={direct|cursor};
#
# For a complete list of connection URL parameters, see the Microsoft SQL Server 2000 Driver for JDBC documentation.
#
# Oracle recommends that you set the SelectMethod cursor to use connections in
# the transactional mode. This enables your applications to have multiple
# concurrent statements open from a given connection, which is required
# for pooled connections.
#
#
# Example of the Microsoft SQL Server JDBC URL
#=======================================================
# Source.url = jdbc:microsoft:sqlserver://dmvqa.oracle.com:1433;databaseName=DMV_qa;selectMethod=cursor;
Source.url = jdbc:microsoft:sqlserver://CRCTSERVER:1433;databaseName=crct;selectMethod=cursor;
# Enter the Microsoft SQL Server database user name. The default for Microsoft SQL Server 2000 is sa.
Source.username = sa
# Enter the Microsoft SQL Server database password. The default for Microsoft SQL Server 2000 is sa.
Source.password = sa
#=======================================================
# ORACLE JDBC CONNECTION SETTINGS
#=======================================================
# Enter the URL for the Oracle9i Database or Oracle Database 10g.
# Oracle uses the JDBC thin driver that is 100% Java.
# You can use an Oracle Database URL similar to the following format:
#
# jdbc:subprotocol:subname@hostname:port(default=1521):SID(default=ORCL)
#
#
# Example of the Oracle Database JDBC URL
#=======================================================
# Target.url = jdbc:oracle:thin:@dmvqa2.oracle.com:1521:ORCL
Target.url = jdbc:oracle:thin:@数据库IP:1521:数据库SID
# Enter your Oracle Database user name:
Target.username = sa
# Enter your Oracle Database password:
Target.password = sa
===================================================================
# DO NOT MODIFY BELOW THIS LINE
===================================================================
#____________________________________________________________
#Note: The Target.queryClassName specified is valid for
#either Oracle9i Database or Oracle Database 10g.
#____________________________________________________________
#
#
# Plug-in Classes
#==================
DatatypeMap.ClassName = oracle.mtg.schemaverifier.map.SQLServerDatatypeMap
Source.queryClassName = oracle.mtg.schemaverifier.query.SQLServer2KQueryComponent
Target.queryClassName = oracle.mtg.schemaverifier.query.Oracle9iQueryComponent
