SSMA convert schema screen freeze

Hello,

I have SSMA 6.0 installed to convert Oracle12 to SQL2014Sp1.  I'm at the "Convert Schema" step for only one Oracle sp (Just want to get comfortable with this before doing all the SPs) and the screen had been frozen for the last 3+ hours.  

I Created Report for the sp_ora (it reported 28 warnings about NUMBER to FLOAT(52) - acceptable)

2.  I then ran Convert Schema..... the Output screen at the bottom said "Conversion finished with 2 errors, 28 warnings, and 37 information messages"

The c:\users\....report\mainindex.html screen pop up for this SP....and this is where the whole screen freeze.  I can't close the html screen.  I click every where on my PC screen and nothing happened.  The Task manager report SSMA running at 0% CPU.  The only way for me to exit this is kill the SSMA process via Task Manager, and I don't think this is the way to exit the process ?

Help.

Thank you



July 27th, 2015 2:23pm

Try to access your SQL server database using SSMS and check whether your procedure migrated? also check for any open connections to the database ? I have faced similar issues when I was migrated huge tables from oracle to SQL Server but it should not happen for just schema conversion. Check all your project settings and change the required data type mappings.

Free Windows Admin Tool Kit Click here and download it now
July 27th, 2015 6:28pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics