Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / synchronize the CRM da...
Microsoft Dynamics CRM (Archived)

synchronize the CRM database with cloud database

(0) ShareShare
ReportReport
Posted on by RohithSankar 25

how to synchronize the CRM database with cloud database

(AWS RDS-SQL server in this case).

 

Scenario is that lets say we have billing calculation done for 10,000 customer on AWS-SQL server. Now this needs to be updated in CRM. Currently we use some sort of synchronization which refreshes each 10 mins and syncs the data from SQL server to CRM. Needless to say we often encounter into error while this sync is being done.

 

It would be nice if someone could suggest a better way to synchronize/transfer this data

*This post is locked for comments

  • Vanda Profile Picture
    Vanda 5 on at
    RE: synchronize the CRM database with cloud database

    You can use Skyvia to import data from Amawon RDS to Dynamics 365: skyvia.com/.../integrate-dynamics-crm-amazon-rds. You need only configure your import/export in convenient GUI wizards and use flexible scheduling settings to automate data operations. You can set the frequency of data updates — for example, once a minute.

  • Verified answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at
    RE: synchronize the CRM database with cloud database

    Adding my two cents:

    If you want to replicate whole database you

    1. can use SCRIBE replicating services also for such scenarios. It will allow your SQL server to sync with Dynamics 365 CE database.

    2. Another options would be to use DataExportServices however it will work only with SQL hosted on Azure I guess.

    If you want to have limited sync (specific entity(s) etc) then

    1. SSIS+KingswaySoft is good option.

    2. LogicApps can also be considered, it offers connectors and can be configured easily, however it can be quite expensive.

    Regards,

    Pranav

    If found useful, please mark the answer as verified

  • Verified answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: synchronize the CRM database with cloud database

    Hello,

    I usually use KingswaySoft adapters for this goal.

    Additionally I can recommend to take a look on architecture of your solution and update not all the customers but those for which data was changed since last sync.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans