I have 3 SQL Server 2008 databases that I need to migrate to Oracle 11gR2 with data only. For all databases I can capture convert, and deploy to the target database. I can also successfully do an online data move for 2 of the databases. The third database runs for about 2 hours and gives a message that the migration completed successfully, but no a single row from any of the tables comes over. How do I figure out what failed. I don't see anything in the reports in SQL Developer (3.2.20.09). To save time and since I am only interested in the tables, indexes and data, after capturing the model, I delete from QL Developer, views, procedures, functions, sequences and triggers before the covert step.
did you delete the views, procedures, functions etc. from the converted model only for the database where you have the problem, or did you do the same for all the three databases?
Have you had a look at the MIGRLOG table in your migration repository? Does it contain any helpful information?
I deleted the views, procedures, functions etc from the captured and converted model for all the databases.
I had a look at the MIGRLOG table and it helped identify my problem. On the problem remote database, the permission was set to data writer instead of data reader.
Thanks for your help