Hi we have a date export made from salesforce instance. We'd like to rebuild just the database but we stumbled on process to import the CSV files to a SQL Server database. We have force.com IDE eclipse plugin, although give you schema explorer there's no way to export this? ERD Tool - I dont need visual I need solid data like xml to rebuild schema. Data loader - no option like this Salesforce - schema builder no option.

ATM we check schemaspy & backup-force.com - but it's so frustrating you can export schema that....

  • I'm not sure what you're asking for exactly. You can use Eclipse.IDE / Metadata API to retrieve XML which represents the objects in your org. In other words, includes the field definitions etc. You can use dataloader etc. to pull the records out. – Doug B Jul 28 '14 at 14:38
  • 1
    If you mean that you want to replicate the schema and data into a SQL Server database, then there are commercial tools that do that. – Keith C Jul 28 '14 at 14:41
  • For example, we use Informatica for this task – Doug B Jul 28 '14 at 15:29
  • For replication schema and data into a SQL Server database, I can recommend you our service - Skyvia. It will create schema automatically and you don`t need to be stumbled on the process of importing CSV files to a SQL Server. In addition, it is a completely no-coding solution in the skin of functional UI. – Jacob Martin Jan 25 '18 at 17:27

There are few Apex exchange tools which can do that for you and also if partners could have build it, there should be a way for the customers to also build it.

Please check the below links which might help you.





| improve this answer | |

Your Answer

