SSMA Extension pack 4.2 installer does not work with clustered environment

Article ID: 2250389 - View products that this article applies to.
Expand all | Collapse all

Symptoms

When installing SQL Server Migration Assistant (SSMA) Extension Pack on a clustered SQL server instance, the name of the SQL clustered instance does not appear as a selection. Instead the name of the machine (cluster node) appears in the drop down list as the name of the SQL Server. As a result, SSMA Extension Pack installation fails on a clustered instance of SQL Server.

Cause

SSMA Extension Pack installation wizard is not supported on a clustered SQL Server instance.

Resolution

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

More Information

 The information in this article applies to the following SSMA products:

  •  SSMA 2008 for Oracle 4.2 Extension Pack
  •  SSMA 2005 for Oracle 4.2 Extension Pack
  •  SSMA 2008 for Sybase 4.2 Extension Pack
  •  SSMA 2005 for Sybase 4.2 Extension Pack
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2250389 - Last Review: September 10, 2010 - Revision: 6.0
APPLIES TO
  • Microsoft SQL Server Migration Assistant 2005 for Sybase ASE v4.0
  • Microsoft SQL Server Migration Assistant 2008 for Oracle v4.0
  • Microsoft SQL Server Migration Assistant 2008 for Sybase ASE v4.0
Keywords: 
KB2250389

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com