I am trying to run the Cloud Migration Tool.
However, I am getting the following error for a bespoke table:
“Could not get the target table count.;Some records failed to be copied, most likely due to mismatch in the source and destination table schemas. Please make sure that fields in your on-premise table do not contain data longer than what can be fit into the cloud table fields.”
I have checked the Field IDs, Data Types, field lengths (where appropriate) and Keys. These all match. I don’t know what else to check?
I am concerned it might be beacuase the Field Names are different (they have had the company prefix added, so “My Table” is now called “ABC My Table”. Could it be this? I would have thought the ID, DataType and field lengths were the crucial factors?
Is anyone able to help me with this query? Thanks.