Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I have a CRM 2011 on-premise system where the historical data (contacts) is missing from last year. The source DB is a different SQL database. My task is to back fill the CRM database with all the missing data from the source. I have never done this task before so I am figuring out the best and safest way to do.
I have researched a bit and listed down the steps. Please let me know if it sounds good.
1. To compare both the databases, CRM and source DB to find out the count of missing data
2. To write a SQL script to update the missing data in the CRM database tables
3. To write a windows scheduler that fires once in a day or so to process certain number of records ( to avoid data load on DB)
Can anyone let me know if this sounds feasible please?
The best way will be to export the data from sql and re-import it .
You can also go for scribe tool or write a SSIS package.
I have modified my question after a bit of research kindly have a look please.
Business Applications communities