Notifications
Announcements
No record found.
Dear All,
I need to migrate data from SQL to Dynamics CRM or vice versa. How can i achieve it with SSIS or any other way without using any third party tool.
*This post is locked for comments
Abhijit,
Refer the following link:
www.concurrency.com/.../using-ssis-import-data-dynamics-crm
blogs.msdn.com/.../integrating-crm-using-sql-integration-services-ssis.aspx
Hope this helps.
Regards,
R.Rajkumar
"Please mark my answer as verified if you found it helpful"
Hi,
If you looking for a tool scribe is the best data mingration tool. you can schedule the replication upto 15 mins intervals and it send periodical reports as well. But the tool is not free. You can have a look
http://www.scribesoft.com/
Hasintha
Hi Rajkumar,
thanks for the link, its help full but also i wish to fetch data from dynamics CRM to SQL. How can i achieve it.
Dynamics CRM Online?
Unfortunately, CRM Online doesn't give you direct access to the database layer via SSMS
Refer this:
stackoverflow.com/.../how-do-i-get-data-from-dynamics-crm-online-in-to-my-sql-server-using-sql
You can write a windows service or can use SSIS to get data from CRM online with the help of CRM APIs. As CRM online is hosted on Microsoft Server you won't be able to access it directly.
Can you provide me the windows service example if possible with code and also SSIS without any third party tool.
Refer the following blog. It explains deeply,
www.c-sharpcorner.com/.../crm-2011-online
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
SA-08121319-0 4
Calum MacFarlane 4
Alex Fun Wei Jie 2
