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....

Improve this question
3
  • 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, 2014 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, 2014 at 14:41
  • For example, we use Informatica for this task
    – Doug B
    Jul 28, 2014 at 15:29

1 Answer 1

Reset to default
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.