0

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
1

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.

https://code.google.com/p/copyforce/

http://sfdc.arrowpointe.com/2007/08/09/replicate-salesforce-schema-to-oracle-or-mysql/

http://www.mydbsync.com/integration/cloud-replication-for-salesforce

http://www.talendforge.org/forum/viewtopic.php?id=30961

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.