1

i migrated an entire oracle Database to SQL Server 2014 Database using SSMA. (SQL Server Migration assistant)

The migration resulted in introduction of multiple Execution calls in my stored procedures (like below):

The module 'INFRA_IP_WEBLOGGER$spCheckIPStatus' depends on the missing object 'sysdb.ssma_oracle.db_check_init_package'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'INFRA_IP_WEBLOGGER$spCheckIPStatus' depends on the missing object 'sysdb.ssma_oracle.db_error_exact_one_row_check'. The module will still be created; however, it cannot run successfully until the object exists.

where INFRA_IP_WEBLOGGER$spCheckIPStatus is one of the Procedure name.

Do i have to install some seperate component so that SQL Server 2014 detects call to sysdb.ssma_oracle

What can i do to fix these errors?

Sana.91
  • 1,999
  • 4
  • 33
  • 52

1 Answers1

1

SSMA relies on some stored procedures added to your SQL Server instance. Look at the manual for "Extension Pack" installation. Something for older version of SSMA is here on MSDN: Installing SSMA Components on SQL Server (OracleToSQL) , but use the manual and extension pack for your specific SSMA version.

IgorK
  • 886
  • 9
  • 26
  • Is there some link available to download / install the extension pack? – Sana.91 Mar 07 '15 at 17:59
  • SQL Server Migration Assistant (SSMA) has own manual, extension pack is part of SSMA downloads. For example, if you used v5.3 for Oracle - http://www.microsoft.com/en-us/download/details.aspx?id=42655 , notice there are 2 installation files, one is for Extension Pack - "SSMA_Oracle\SSMA for Oracle.5.3.0.ExtPack.exe". But you need to install extension pack from the same version of SSMA that was used to convert the database. – IgorK Mar 08 '15 at 08:17
  • Manual is embedded in SSMA, Help > Help (F1) and find "Installing SSMA Components on SQL Server (OracleToSQL)". – IgorK Mar 08 '15 at 08:22