CRM 2011 On-premise database update of missing historical data from different database

(0) Share

Report

Posted on by user123

147

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

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
user123 147 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohd

I have modified my question after a bit of research kindly have a look please.

Regards

ABa

Was this reply helpful? Yes No