DB migration from sql (sql server 2019) to oracle 12c using sql developer 19.2

[kiranp]

Hi Erman,
I did go through http://ermanarslan.blogspot.com/2019/10/rdbms-migrating-from-microsoft-sql.html, before coming to your article I did perform all these steps mentioned but no luck.
Can you please let me know if we can migrate DB from sql (sql server 2019) to oracle 12c using sql developer 19.2 or new versions?

[ErmanArslansOracleBlog]

I didn't test SQl Developer with those source and target database versions, but I think you can do that..
The same logic applies.
See -> https://www.oracle.com/database/technologies/migrating-sql-to-oracle.html

[kiranp]

I did follow the steps mentioned in the URL but it is clearly mentioned that sql developer supports sql server version till 2008 R2 only.  There is no latest release notes, so not sure if it really supports.  At least when I tried it went into loop for 13 hours and later I cancelled it.  Note that my DB size 5 GB with 60,000 tables.

[ErmanArslansOracleBlog]

It is not supported. But this doesn't mean that it will not work. It means it may not work and Oracle will not support you on that..

So please investigate your issue.. Check Oracle sessions, check SQL Developer sessions as well. Maybe  it is waiting something in the db, it may be blocked due to some wait.. We got to see that..
If all the session are inactive and idle; only then we can suspect from the internal working of Sql Developer there..

[kiranp]

ok.  Thank you.