I've migrated several databases from SQL server to Oracle using the OMWB
tool. DON'T use the OMWB that is located in the client; It's always out
of date and never works.

Download the latest OMWB and unzip it into a workstation directory. You
Might have to download the SQL 2000 jar file. Rename it to a zip when
you get it and extract it to the bin directory.
Also, have an ODBC connection to the SQL server box on this workstation,
and then experiment.

Oracle has a five day class on the OMWB, but it's not to tough to figure
out. Plan on migrating the database about 20 times if you are new to the
tool. The more you learn how to make tweaks during the 'mid-migration',
the less backend stuff you will have to address.

Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]


-----Original Message-----
From: Abdulla_Saiyed
[mailto:oracledba-ezmlmshield-x76294760.[Email address protected]
Sent: Tuesday, March 06, 2007 3:06 AM
To: LazyDBA Discussion
Subject: convert SQLServer-2000 Data to Oracle

Hi,

Does anyone have any idea how to convert SQLServer-2000 Data to Oracle..
please send me reply it's urgent








---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page