Good morning,
I am trying to export an entity (custom) to my BYOD. I was able to export it when there was no data (when I was in the DAT company), but when I tried to run it under another company I get the following error: Export failed while copying data from staging to target:
I have refresh the entities and remapped them, but I am not sure what else do I need to do.
Any ideas?
Thanks
Hi Astrid,
Please export this entities in other companies than DAT in Excel to check if it works.
If it works properly, try to republish the entity to Azure SQL database again and create a new export project and export to Azure SQL DB (BYOD).
Hi,
To solve the problem you need to give appropriate grant/permission to your DB like insert. and after that Please try to drop the table in the database, republish the entity and export again.
Any update on this? I am also getting the same error.
The issue we has was the index that the entity creates when published, I drop the index and I was able to export.
How did you drop the index?
Hi Nissaka, You can drop index by connecting to BYOD Database in SQl server, find your staging table, expand it, Indexes (Right click and Delete).
Please note that you have to perform same step if you re-publish the Data entity to BYOD.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 703 Super User 2025 Season 2
Martin Dráb 582 Most Valuable Professional
CA Neeraj Kumar 542
