Hi,
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 Field" is now called "ABC My Field"). Could it be this? I would have thought the ID, DataType and field lengths were the crucial factors?
What is more, I have just noticed, is that I have entries marked as 'successful', yet not a single record has been copied....
Is anyone able to help me with this query? Thanks.
