How do I export everything from Sugar? I just want my own clean copy of everything from the prospects name, address, interest and everything else plus the contact history and notes. I fear I can't get all this. Does anybody know? Thanks in advance.
If you are looking for a full backup of all data in your instance, you could generate a backup of your entire database. This would allow you to extract the data into a SQL file which you could then store for safekeeping, manipulate using a database tool, etc.
If your instance is hosted on-site, you can follow step 2 for extracting the database in our Moving Sugar to Another Server article in the Knowledge Base.
If your instance is hosted on-demand, you can file a support case with SugarCRM Support, asking for a backup of your Sugar instance to be provided to you.
If you just want to extract some data, but not the entire database, there are two routes you could pursue:
Each of those options would allow you to export data into CSV files, which then can be opened using a spreadsheet application such as Excel.
Information pertaining to export of data can be found in the Sugar Application Guide at: http://support.sugarcrm.com/Documentation/Sugar_Versions/7.8/Pro/Application_Guide/Export/index.html
Regards,Patrick SullivanSugarCRM Support
Hi Patrick, thanks for the reply. I am looking to do a full backup of the Entire database. I'm not sure what you mean by hosted On-site. Do you mean Onsite at my location or Onsite with Sugar? Regardless, like I said, I need to export the Entire database. If SQL is the only way, as opposed to SQL, so be it. I can't figure out how to do it and I need to do it yesterday. Please help. Thanks!
On-site (or on-premise) would mean having your instance of Sugar hosted on your own server, or a server that you control. On-demand would be when SugarCRM, the company, is hosting the instance on our servers for you; this usually means that your instance URL contains "sugaropencloud.eu" or "sugarondemand.com" within it.
Thank you for the rapid response! It is hosted Online by Sugar, so On-Demand.
Feel free to file a support case at support.sugarcrm.com or by emailing firstname.lastname@example.org and we can generate a full backup of your instance to provide to you.
You can export all your data from SugarCRM to SQL databases or DWH, with the help of Skyvia.
Retrieving data ...