+ Start a Discussion
Vaishali mehtaVaishali mehta 

Hello All, I am moving an existing application which is currently having an oracle db to salesforce. What are the possible ways for data migration? Which will be the most efficient and why? Thanks in advance!

I am moving an existing application which is currently having an oracle db to salesforce. What are the possible ways for data migration? Which will be the most efficient and why?
Rahul KumarRahul Kumar (Salesforce Developers) 
Hi, Vaishali,

In my opinion, it is better to achieve the migration using the Data Loader, when you can, than it is to write Apex, but as with everything, it depends on the specific scenario.

Benefits of using the Data Loader:
You don't have to worry about coding errors when you use the Data Loader.
You don't have to worry about limits as much. For example, if you are migrating a sizeable number of records you'll quickly run into limits with the number of records returned by your SOQL query. That being said, there are sometimes when Apex might be the way to go.
You have complex business logic that isn't as simple as exporting one Object's fields and importing to another. In this case, I'd recommend creating a Batch Apex job, unit testing it, and testing it in a sandbox prior to production.


You have an Object that has a few (e.g., 10) records and you are copying a value from one field to another field. Anonymous Apex would be reasonable to me. With this small data set, it's simple, easily verifiable, and you likely won't hit limits.

hope it will be helpful.

Please mark it as best answer if the information is informative.so that question is removed from an unanswered question and appear as a proper solution.
 
Evelina GreyEvelina Grey
Hi, Vaishali!

For this purpose, we used a 3rd party tool - Skyvia. We migrated our data without coding and it saved us a lot of time. You can read more here: https://skyvia.com/data-integration/integrate-salesforce-oracle (https://skyvia.com/data-integration/integrate-salesforce-oracle https://skyvia.com/data-integration/integrate-salesforce-oracle)