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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .