Share
Report
145Hi
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?
Regards
ABa
*This post is locked for comments
All responses (
Answers (
