SSMA for Oracle Crash at Data Migration

Madhan Kumar 0 Reputation points
2023-11-11T17:39:16.4966667+00:00 
 Hi,

   I am working for Oracle to SQL Server Migration through SSMA. 

i migrated tables structure to sql server.  it has around 4800 Tables. it takes lot of time to create structure as well as analyse metadata. 

Migrating data... 

Analyzing metadata...

   it takes around 7-8 hours to get analyze metadata. 

 when i do migrate data ssma crash automatically and closes immediately.  i tried multiple times.

i get below details at event viewer. 

Application: SSMAforOracle.exe

Framework Version: v4.0.30319

Description: The process was terminated due to an unhandled exception.

Exception Info: System.AccessViolationException

   at System.Data.Common.UnsafeNativeMethods+IRowset.ReleaseRows(IntPtr, System.Runtime.InteropServices.SafeHandle, IntPtr, IntPtr, IntPtr)

   at System.Data.OleDb.OleDbDataReader.ReleaseRowHandles()

   at System.Data.OleDb.OleDbDataReader.ReleaseCurrentRow()

   at System.Data.OleDb.OleDbDataReader.ReadRowset()

   at System.Data.OleDb.OleDbDataReader.Read()
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,214 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-11-13T06:10:01.1033333+00:00

    Hi @Madhan Kumar

    Not an expert on SSMA.

    Not sure if this post can help you.

    https://dba.stackexchange.com/questions/133651/why-sql-server-migration-assistant-keeps-crashing-on-the-migrate-data-step

    Best regards,

    Percy Tang

    0 comments