InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 12:00:39 GMT20http://www.sqlservercentral.com/Forums/Topic1252777-363-1.aspxHi,In my current job the Cozyroc componets are used and I can recommend them. It´s a supported way to write data into the CRM entities. However, to make a backup you don't need to write data, instead you just need to read data. To solve your issues:1. How do I obtain a list of all entities -- Use the data dictionary (i.e. InformationSchema System Views)2. How do I obtain a list of all fields within each entity -- Use the data dictionary (i.e. InformationSchema System Views)3. How can I download - lets say 500 records at a time. -- Use the Cozyroc library, make your own component extension. The problem hier is how to make a kind of batch/bulk request to the web service. The Cozyroc "Dynamic CRM Source" has an option called "BatchSize" (Specify the number of rows to be retrieved as a batch. The maximum is 500.) [url=http://www.cozyroc.com/ssis/dynamics-crm-source]Here [/url]is the link to the documentation. I think you could try it for free. If not you could always extend a component, but you have to put in a balance the development cost and time in order to accomplish such a task.Kind Regards.Mon, 18 Feb 2013 05:43:44 GMTPaul Hernándezhttp://www.sqlservercentral.com/Forums/Topic1252777-363-1.aspxHello,I tried to use SSIS 200R2 and Dynamics CRM Online but I have an error when I tried to authenticate Dynamics CRM Online from Dll 3.5 library proxy.Did you succed the authentication ?please help me.Thanks in advaned,Ramdane.Fri, 15 Feb 2013 03:22:28 GMTramdane.berkanehttp://www.sqlservercentral.com/Forums/Topic1252777-363-1.aspxAnother inexpensive alternative for SSIS is the [url=http://www.cozyroc.com/][b]COZYROC SSIS+[/b][/url] library. It includes Dynamics CRM adapters among many other useful extensions. All deployment types are supported: Premise, Live, Hosted, Federation. No programming skills are required. The pricing starts at $399.95/YearFri, 21 Dec 2012 20:11:31 GMTCozyRochttp://www.sqlservercentral.com/Forums/Topic1252777-363-1.aspxWriting C# code in SSIS to talk to CRM web service is not an easy take. We have an affordable solution which you can check out. [url=http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-crm]http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-crm[/url]Tue, 06 Mar 2012 08:48:49 GMTdanielcaihttp://www.sqlservercentral.com/Forums/Topic1252777-363-1.aspxHiMS Support provided me this information. That we may all find useful in relation to this query.http://msdn.microsoft.com/en-us/library/cc151047.aspxAny further info on initial question and above is welcomeHow can I download more that 1 record at a time from MS Dynamics CRM Online 2011ThanksThu, 16 Feb 2012 08:05:51 GMTpukkaukhttp://www.sqlservercentral.com/Forums/Topic1252777-363-1.aspxI would like to backup MS Dynamics CRM 2011 Online using SSIS. My current code allows me to download known entities and known fields one record at a time. The issues I have to solve include..1. How do I obtain a list of all entities2. How do I obtain a list of all fields within each entity3. How can I download - lets say 500 records at a time.I do not want to use expensive ETL tools. I prefer to use SSIS.Wed, 15 Feb 2012 15:11:50 GMTpukkauk