I am using the latest update (126.96.36.199beta) with the migration toolkit in EDB. I was able to make a connection to the oracle database that we wanted to migrate but found some significant issues with the migration tool that has effectively been a showstopper at this point. Theses issues are:
1. While migrating Shcemas and Tables I noticed loads of errors show the inability to migrate or create certain fields/columns in the oracle database (mainly those of type ORDVIDEO). It seems there is no equivelant type in EDB so it just refuses to make that field/column and then as a resuly we lose all data contained in those fields/columns. We simply cannot have that much data just left out.
2. I have also noticed that even though it says it successfully migrates all triggers/procedures/views/sequences, When I look at the EDB copy of this database none of these are there. We use those items heavily and need them migrated if this is going to be a viable tool for migration.
This is my first two attempts at this migration process and frankly I am not even sure that I am doing this correctly as I have yet to see any real documentation on the migration tool itself. I would love to know if these are known issues, is there a workaround, am I simply misssing steps to prepare for the migration, is there going to be an update that address's these problems if they are a known issue, is there. or will there be documentation one can read to solve these issues?
Please any help on this would be greatly appreciated and also a good feather in EDB's cap as we do business from coast to coast and would love to boast EDB as our primary data solution covering millions of records.