SQL Server Migration Assistant for Oracle problem

Hi ferrethouse,

I can give here some hints about the way SSMA works with Java runtime.

When started, SSMA looks into the registry and tries to locate a directory as a value of this key

HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Runtime Environment\1.4\JavaHome

If it finds 1.4, it checks that JRE version is not earlier than 1.4.2_06. If there is no 1.4 version altogether, it will look for

HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Runtime Environment\1.5\JavaHome

SSMA can work on JRE 1.5, but not all features have been successfully tested on that JRE so far.

Generally, the tool is able to choose the JRE it needs, if several Java versions are installed side by side.

In your case, the following order of steps may help:

- Uninstall both Java and SSMA

- Reboot Windows

- Install JRE 1.4.2_12

- Install SSMA 2.0

Best wishes,

= = Yuri Rusakov,

SSMA team, Ukraine