CRM 4.0 中的数据库变化
有人告诉我，roumerred，但找不到任何书面证据表明，如果您通过使用 TSQL 手动将数据脚本写入数据库来修改数据库，这将使您与 Microsoft Dynamics CRM 4.0 的支持合同无效。
任何人都可以帮忙提供链接或确认这是真的吗？
预先感
谢伊恩
I have been told, roumerred, but can't find any documented evidence that it will invalidates your support contract with Microsoft Dynamics CRM 4.0 if you modify the database by scripting data into the database manually using TSQL.
Can anyone help with a link or confirmation that this is true.
Thanks in Advance
Iain
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
作为 Microsoft 合作伙伴，我可以自信地说，如果 Microsoft 发现您这样做了，他们基本上会告诉您您进行了不受支持的更改，并且在您不先进行全新安装的情况下不会帮助您处理系统。我不相信你的保修“无效”，但我可能是错的。
话虽这么说，他们知道您是否执行了直接 SQL 插入的唯一方法是您是否操作错误。不过，我不建议您尝试这样做。有一些中间件解决方案可以实现此目的，或者您可以使用 SDK 编写自己的导入工具。
As a Microsoft partner I can say with confidence that if Microsoft discovers that you did this, they will essentially tell you that you made unsupported changes and won't help you with your system without you first doing a fresh install. I don't believe you "invalidate" your warranty, but I could be wrong about that.
That being said, the only way they'll know that you did direct SQL inserts is if you do it wrong. I DON'T recommend you attempt this, however. There are a few middleware solutions to achieve this or you could write your own import tool using the SDK.
我们当时通过一些首次集成来解决这个问题，我也听到了与您相同的谣言。如果 MS 得知您已直接手动将数据输入数据库，他们将在提供支持之前强制重新安装。
这是一种耻辱，因为将数据直接转储到数据库中是非常诱人的。 CRM API 的速度并不是非常快（实际上有点术语），并且利用 API 的想法对于许多 ETL 开发人员来说有点令人生畏。
我们最终随时使用 Scribe Insight (http://www.scribesoft.com/) 作为我们的集成平台我们将数据推送到 CRM 中。它不是一个完美的 ETL 工具，但对于 CRM 集成来说它非常接近。事实证明，这比编写自己的 C# 库来处理这一基本任务要高效得多。
如果您正在考虑使用 tsql 将数据推送到 MS CRM，那么请不要这样做。首先看看该产品。
We fought this with a few of our first integrations back in the day, and I have heard the same rumors you have. If MS learns that you've manually entered data into the database directly, they will force a reinstall prior to supporting.
This is a shame, because it is very tempting to dump data directly into the database. The CRM API isn't extremely speedy (it's actually a bit of a terd) and the idea of leveraging the API is a little intimidating to a lot of ETL developers.
We ended up using Scribe Insight (http://www.scribesoft.com/) as our integration platform anytime we push data into CRM. It's not a perfect tool ETL tool, but for CRM integrations it's pretty close. This has proven to be far more efficient than writing your own C# libraries to handle this basic task.
If you're thinking about pushing data into MS CRM with tsql - don't. Give that product a look first.