Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Currently, we have a lot of Sandbox instances for development purposes, and we are trying to lower storage capacity in our lower orgs. The issue is that we need some data to come down from production for development purposes, but we probably only need about a year worth of data. The two only option is a full copy or a copy with customization and schema. Is anyone familiar with a tool we can use after a copy? Currently, we onpen ticket to truncate the audit log table and delete any emails with attachments to free up space in lower orgs.
Hi Jose Fleitas,
This article explains how to copy an environment. If you want to delete data after finishing the copy, you can achieve this with the bulk deletion feature.
I already know how to copy an environment, and I am familiar with bulk delete. IWe have a lot of custom entities and data. This is to much work to run bulk delete jobs. Also, I wasn't asking on how to do a copy.
There are tools you can use to copy data or delete data after you did a full copy of instance. Most of the tools will work fine if you do not have many tables (entities) and if you do not have loads of relationships.
You could do a "Copy Schema Only" and the use the configuration migration tool to migrate or copy data over from Prod to Dev. In the configuration migration tool, you can now filter records using FetchXML so may be you could have your date filter in there.
There is one other option I normally follow is to write linqpad script in c# that loops though list of entities and copy the data (obviously you will have to created the records in order). The script based approach is very flexible as you can have any filter or condition you want.
If you go with Full Copy approach, then you can delete audit logs and attachments to reduce the size and then use Bulk Deletion job or third party tool like XrmToolBox to delete the unnecessary data.
This XrmToolBox plugin allows you to select a view or paste FetchXML so filtering and deleting is fairly straightforward. The difference between OOB bulk delete job and this tool is that this tool does instant deletion where as the system job is async will take longer.
Our environment has a lot of entities and is heavily customized. I am not familiar with the migration tool. Does it migrate over the actual data? I am aware of a copy with customization and schema, but the question is how do I delete all data in the system older than say a year. For bulk delete, I am familiar with the tools and xrmtoolbox. Our audit logs are about 200 GB in production since we use this data past year audit, so this is not a simple task. Microsoft truncates the table for us which takes about 15 minutes. Attachments; I delete all attachments in lower orgs. I am looking at an attachment extractor tool in app source to store attachment in cheaper storage.
Business Applications communities