SSMA Extension pack 4.2 installer does not work with clustered environment

In clustered environments, the SSMA Extension Pack can be manually installed using one of the procedures that is applicable to your environment.

SSMA for Oracle Extension Pack installation on SQL Server 2008: 

1. Run SSMA 2008 for Oracle 4.2 Extension Pack on one of the clustered SQL Server node.
2. Proceed with the installation instructions until the following message appears ‘Completed the First Step of Installation’. Click Next to continue.
3. Click Cancel to exit the installation when presented with dialog box to select SQL instance.
4. Locate the ‘SSMA Install Path’ directory where the SSMA Extension Pack script files are installed (e.g. D:\Program Files\Microsoft SQL Server Migration Assistant 2008 for Oracle Extension Pack\). There should be two subdirectories - \bin and \scripts.
5. Copy the \bin directory to ALL SQL clustered node machines (Note that the \bin must have the same path on all nodes) or copy the \bin directory to a shared location that is accessible from both nodes.
6. Locate the \scripts directory in the ‘SSMA Install Path’ (e.g. D:\Program Files\Microsoft SQL Server Migration Assistant 2008 for Oracle Extension Pack\scripts)
7. Manually replace all %SSMA_O2SS_EP_HOME% occurrences with the path where the \bin folder is located. in the following scripts:
             \scripts\migration-with-bcp.sql 
             \scripts\register_clr.sql
             \scripts\register_clr2008 
             \scripts\register_external.sql
8. Manually replace three occurrences of %PLATFORM% in 'scripts\register_external.sql' with appropriate platform modifier -win32|x64|itanium.
9. Manually replace %SSMA_MK_PASSWORD% in \scripts\migration-with-bcp.sql with strong password according to your network policy.
10. Connect to your SQL Server 2008 clustered instance and run the following scripts on 'master' database in the specified order:
              \scripts\drop-db-2005.sql
              \scripts\register_external.sql 
              \scripts\create-db-2005.sql
11. Connect to your SQL Server 2008 cluster instance and run the following scripts on 'sysdb' database in the following order:
              \scripts\register_clr.sql 
              \scripts\clr_routines.sql 
              \scripts\migration-with-bcp.sql
              \scripts\exceptions.sql
              \scripts\utl-file-impl.sql
              \scripts\packages.sql
              \scripts\standard.sql
              \scripts\standard2008.sql
              \scripts\sequences.sql
              \scripts\records.sql
              \scripts\other-packages.sql
              \scripts\collection-accessors.sql
              \scripts\collection-methods.sql
              \scripts\collection-helpers.sql
              \scripts\lob_output.sql
              \scripts\dbms-lob-impl.sql
              \scripts\register_clr2008
              \scripts\packages2008 
              \scripts\clone_assembly.sql
              \scripts\datetime.sql
              \scripts\dbms-sql-impl.sql

SSMA for Oracle Extension Pack installation on SQL Server 2005

1. Run SSMA 2005 for Oracle 4.2 Extension Pack  on one of the clustered SQL Server node.
2. Proceed with the installation instruction until the following message appears ‘Completed the First Step of Installation’. Click Next to continue.
3. Click Cancel to exit the installation when presented with dialog box to select SQL instance.
4. Locate the ‘SSMA Install Path’ directory where the SSMA Extension Pack script files are installed (e.g. D:\Program Files\Microsoft SQL Server Migration Assistant 2005 for Oracle Extension Pack\). There should be two  subdirectories -  \bin and \scripts
5. Copy the \bin directory to ALL SQL clustered node machines (Note that the \bin must have the same path on all nodes) or copy the \bin directory to a shared location that is accessible from both the nodes.
6. Locate the \scripts directory in the ‘SSMA Install Path’ (e.g. D:\Program Files\Microsoft SQL Server Migration Assistant 2005 for Oracle Extension Pack\scripts)
7. Manually replace all %SSMA_O2SS_EP_HOME% occurrences with the path where the \bin folder is located. in the following scripts:
           \scripts\migration-with-bcp.sql 
           \scripts\register_clr.sql
           \scripts\register_external.sql
8. Manually replace all occurrences of %PLATFORM% in 'scripts\register_external.sql' with appropriate platform modifier -win32|x64|itanium.
9. Manually replace %SSMA_MK_PASSWORD% in \scripts\migration-with-bcp.sql with strong password according to your network policy.
10. Connect to your SQL Server 2005 cluster instance and run the following scripts on 'master' database in the specified order: 
            \scripts\drop-db-2005.sql
            \scripts\register_external.sql
            \scripts\create-db-2005.sql
11. Connect to your SQL Server 2005 cluster instance and run the following scripts on 'sysdb' database  in the following order:
           \scripts\register_clr.sql
           \scripts\clr_routines.sql
            \scripts\migration-with-bcp.sql  
            \scripts\exceptions.sql
            \scripts\utl-file-impl.sql
            \scripts\packages.sql
            \scripts\standard.sql
            \scripts\standard2005.sql
            \scripts\sequences.sql
            \scripts\records.sql
            \scripts\other-packages.sql
            \scripts\collection-accessors.sql
            \scripts\collection-methods.sql
            \scripts\collection-helpers.sql
            \scripts\lob_output.sql
            \scripts\dbms-lob-impl.sql
            \scripts\datetime.sql
            \scripts\dbms-sql-impl.sql

SSMA for Sybase Extension Pack installation on SQL Server 2005 and 2008:  

1. Run SSMA 2005/2008 for Sybase 4.2 Extension Pack on one of the clustered SQL Server node.
2. Proceed with the installation instruction until the following message appears ‘Completed the First Step of Installation’. Click Next to continue.
3. Click Cancel to exit the installation when presented with dialog box to select SQL instance.
4. Locate the ‘SSMA Install Path’ directory where the SSMA Extension Pack script files are installed (e.g. D:\Program Files\Microsoft SQL Server Migration Assistant 2008 for Sybase Extension Pack\). There should be two subdirectories - \bin and \scripts .
5. Copy the \bin directory to ALL SQL clustered node machines (Note that the \bin must have the same path on all nodes) or copy the \bin directory to a shared location that is accessible from both nodes.
6. Locate the \scripts directory in the ‘SSMA Install Path’ (e.g. D:\Program Files\Microsoft SQL Server Migration Assistant 2008 for Sybase Extension Pack\scripts)
7. Manually replace all %SSMA_S2SS_EP_HOME% occurrences with ‘SSMA Install Path’ in the following scripts: 
             \scripts\migration-with-bcp.sql
8. Manually replace %SSMA_MK_PASSWORD% in 'scripts\migration-with-bcp.sql' with strong password according to your network policy.
9. Connect to your SQL Server 2005/2008 cluster instance and run the following scripts on master database in the specified order:
             \scripts\drop-db-2005.sql
             \scripts\create-db-2005.sql
10. Connect to your SQL Server 2005/2008 cluster instance and run the following scripts on sysdb database in the same order:
              \scripts\migration-with-bcp.sql
              \scripts\sysdb_sybase.ssma.sql