Dear all,
I am searching for the best practise to integration sql database and 365 on premise(two ways integration) and it should be synchronous. i was thinking about SSIS or sql triggers by calling D365 api. no need for paid solutions.
any suggestion please.
with regards.
Hey Ibrahim,
One of the options that I can think of would be the SQL server replication feature.https://docs.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication?view=sql-server-ver15
Sharing Data across Microsoft Dynamics CRM Deployments ::https://cloudblogs.microsoft.com/dynamics365/no-audience/2010/03/23/sharing-data-across-microsoft-dynamics-crm-deployments/
Here is an example of doing this with Azure SQL DB ::https://community.dynamics.com/crm/b/nishantranaweblog/posts/using-sql-server-transactional-replication-to-move-data-from-sql-server-on-prem-to-azure-sql
A related community thread where some other options were being talked about ::https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/110758/sync-framework-to-update-external-database?pifragment-97030=1
Please mark my comments as answered if this helps. Thanks,
Saurabh
Dear,
if i want to go with ssis solution, how to run the deployment synchronously(once create or update a record)?
as i know, i need to schedule the packages (asynchronous).
regards,
Dear Partner,
Multiple ways like SSIS, Kinfsway soft or Muelsoft can be used its completly depend on your requirement.
Regrads,
Mohamed Sanuj Basheer
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 258
MVP-Daniyal Khaleel 182
Tom_Gioielli 125 Super User 2025 Season 2
