I'm trying to migrate a database created in SQL Server 2016 to Oracle 18c.
Both database instances are installed in VMs.
However the migration fails providing a message which I could not understand as I'm not that deep into Oracle RDBMS.
Now, both VMs have 4GB of RAM and each one is used to host the specific RDBMS (SQL Server 2016 & Oracle 18c respectively)
Both RDBMSs were installed with default options. The origin database (SQL Server 2016) is a very simple one, no triggers or stored procedures or anything like that. It only has PK-FK constraints for table relations.
The target database is an empty DB (or User as Oracle calls it) with all privileges provided in the options.
The process is followed with the default options in the migration wizard, with the only option selected it to truncate the target DB (if there are any tables....in my case I don't really care since I want a clean migration from scratch, both structure and data). The error shown states the following : "Cannot retrieve object if key is not set". I couldn't find anything so far regarding the issue.
SQL Server 2016 OS is Windows Server 2016, Oracle 18c OS is 2008R2 Datacenter edition.
Please let me know If you need any further details that can help.
What I have tried:
Tried migrating from SQL Server 2008 R2 just in case there is an incompatibility. Granted all privileges to the DB. Tried to migrate only the DB constraints (the DB does not have any indices, triggers or stored procedures).
Submit an article or tip