function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
cherialcherial 

Importing External Database schema....

Is there any way to import external database schema into Salesforce.com platform?

If possible please guide me how to import.

Thanks,
-Nath
Drew1815Drew1815
There are no ways to import a schema directly from an external database.
But the Force.com Metadata api allows you to create custom objects and fields without having to add each object and field through the UI.

One solution would be to use the Force.com IDE (which uses the metadata api) to create your Force.com schema. You will still have to map your external schema into Force.com custom objects and fields. The metadata api uses XML files to create/modify Force.com objects , so you would have to map your external schema into the required Force.com XML files. Then you can automate the creation of the Force.com database.

Here is a link to the Metadata API documentation: http://www.salesforce.com/us/developer/docs/api_meta/index.htm
Here is a link to the Force.com IDE documentation and installation guide: http://wiki.apexdevnet.com/index.php/Force.com_IDE

I hope this helps.

Andrew