Friday, April 20, 2012 2:58 PM
Using SQL Server Migration Assistant for Oracle. Success for most of the tables except 2 are very large. Too many rows for the Oracle server to handle it. Is there a way to break the data migration into more than one batch load in SSMA? I can't see a way to do so...
Monday, April 23, 2012 6:23 AMModerator
What error messages you received when the migration failed?
For your requirement, breaking the data migration, I think we can deal with it on the oracle side, maybe we can cut the table into several small tables and migrated.
Please post the error message if you have received when you are migrating the data. It is helpful for us to troubleshoot the issue.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Tuesday, May 01, 2012 9:32 AM
please check the below link.