Salesforce到SQL / .NET迁移 [英] Salesforce to SQL / .NET migration

问题描述

你好亲爱的CPians，



我有一项迁移Salesforce DB的任务。我还没有确定在.net环境中迁移此DB以使用它的正确方法是什么。到目前为止，我的想法是将数据库迁移到SQL Server或实体框架代码优先实现。如果您有这方面的经验，请告诉我一条可以遵循的路径或者我应该如何从这开始的建议？到目前为止，我看到了一些第三方迁移工具。



提前致谢。



我尝试了什么：



一直在google上研究如何在谷歌上实现这个实现。

查找第三方应用程序作为Skyvia，RazorSQL，dotConnect for Salesforce。

Hello dear CPians,

I have a task to migrate a Salesforce DB. I haven't decided what is the proper way to migrate this DB to use this in .net environment. So far I have thoughts in my mind as migrate the DB to SQL Server or Entity Framework Code First Implementation. If you have any experience in this area can you please show me a path to follow or any suggestions how I should start with this? So far I see some 3rd party tools for migration.

Thanks in advance.

What I have tried:

Been researching on google how to do this implementation on google.
Find 3rd party apps such as Skyvia, RazorSQL, dotConnect for Salesforce.

推荐答案

从我读到的内容此处，Salesforce DB使用Oracle数据库。实体框架可以使用 oracle数据库。

来自我在第一篇文章中读到的内容，从Salesforce迁移到您可以控制的内容（假设迁移的原因），可能是一项非常重要的工作。请注意，它不一定是一些标准化的数据集。您的企业可能已对标准数据集进行了多次自定义。或许可以采用不同的方法将其保留在原处，使用EF访问它并构建您想要的应用程序。另一种可能性是使用EF来创建首先从数据库中获取代码。将它指向salesforce中的数据库，让它为您生成代码优先实现，在web.config中切换目标，并在SQL Server中创建数据库。



如果你想进入更具体的细节，请随意... [e-mail]



HTH，

Mike

From what I read here, the Salesforce DB uses an Oracle database. Entity Framework can use an oracle database.
From what I read in the first one, the migration from Salesforce to something that's under your control (assuming that the reason for the migration), could be a really big job. Note that it's not necessarily some standardized set of data. Your enterprise may have made several customizations to the standard data set. Perhaps a different approach could be to leave it where it is, use EF to access it and build the apps you want. Another possibility might be to use EF to create a 'code first from database'. Point it at the database you have in salesforce, have it generate the code-first implementation for you, switch the destination in web.config, and have that create the database in SQL Server.

If you want to get into more specific details feel free... [e-mail]

HTH,
Mike

如何将数据从SalesForce加载到MS SQL Server - Blendo [ ^ ]

这篇关于Salesforce到SQL / .NET迁移的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！