65
Dear All,
We are migrating crm 2013 to crm 2016 onpremise.We have huge attachments .Annotation table size is 245 GB.
Org DB size us 350 GB.
we want to keep the attachments as is.
What will be best approaches while migrating using Organization import approach?
*This post is locked for comments
The approach will work but it is unsupported.
If it is onprem then simply import the org - 300 GB isn't that big that import wont handle. You can always involve support team in case you get error. But with direct CRM table manipulation even the support team wont be able to help since you went the unsupported way.
Thanks David
To make the import fast we are thinking of below approach please guide us.
1. Restore the Org DB on sql server 2014.
2. Take a backup of Annotation table in a new custom DB.
3.Set the documentbody column of Annotation table to Null.
4.Shrink the Org DB to reclaim the attached files space.
5.Import the Org
6. Update the documentbody from Backup table
Is this approach right?
If you're doing an organisation import, then I don't think the size of the attachment table will have much impact on the time it takes, as it won't need to process the data in any way. It would affect the time to copy or backup/restore the database, but that's not normally a large part of the overall upgrade time
According to me, best approach to save the Storage would be to move the Attachments to Azure Blob or Sharepoint.
Add a link to that file on storage location to the actual CRM record.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (