从MS Access更新到SQL [英] Updating from MS Access to SQL

问题描述

当在MS Access 2003数据库中更新地址时，需要将其发送到SQL Server 2005中的主地址数据库。我原本打算使用BizTalk创建一个Web服务更新主SQL DB中的地址，然后使用MS Access Web服务工具包向该Web服务发送地址更新。

现在我想知道我是否可以在BizTalk中设置一些东西，定期轮询MS Access寻找更新，然后将它们发送到SQL。 BizTalk可以实现吗？

我真的需要获得开发人员版本并开始搞乱，但在此之前知道这是否可行将有助于规划。

- Eisen

---

*注意：我没有正式的CS教育，所以请谨慎对待所有建议：）

解决方案

我认为Biztalk在这里可能有点矫枉过正。
您应该看一下Sql Server Integration Services。 http://msdn.microsoft.com/en-us/library/ms141026(SQL 0.90）的.aspx 结果

Hi,

When an address is updated in an MS Access 2003 DB it needs to be sent over to our main address database in SQL server 2005. I was originally thinking to create a web service using BizTalk to update addresses in the main SQL DB and then using the MS Access Web Service Toolkit to send address updates to that web service.

Now I am wondering if I can set up something in BizTalk that periodically polls MS Access looking for updates and then ships them over to SQL. Is this possible with BizTalk?

I really need to get the developer version and start messing around but until then knowing if this is possible will help in planning.

- Eisen

---

* Note: I have no formal CS education, so take all advice with caution :)

解决方案

Hi,
I think Biztalk might be a bit overkill here.
You should take a look at Sql Server Integration Services. http://msdn.microsoft.com/en-us/library/ms141026(SQL.90).aspx

这篇关于从MS Access更新到SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！