将SQL表记录从本地服务器更新到WebServer [英] Update SQL Table Records from Local Server to WebServer

问题描述

嗨朋友，

我从我的客户端获得了一项任务（即）使用C＃和SQL创建Windows应用程序使用两台SQL Server，一台有本地服务器，另一台是WEB服务器...条目将直接存储在LOcal Server中（bcoz有时会出现Internet连接问题）...现在我该怎么办？我如何更新recodrs（仅限每日条目记录）从本地服务器到Webserver表（每日更新或基于小时数）更新）..

如果您对自动更新流程有任何了解更好...在此先感谢.....

解决方案

< blockquote>如果数据库是本地和Web服务器中的真实副本，您可以根据上面问题中ThePhantoomUpvoter提供的注释来同步它们，您可能需要运行定期运行的计时器并从本地更新数据服务器到Web服务器。



为简化起见，您可以在本地数据库中添加isWebUpdated字段，并在ev中将其设置为Zero插入。将数据更新到Web服务器后，将此字段更新为1.

Hi Friends,
I got one task from my Client (i.e) Creating Windows Application using C# & SQL Using Two SQL Servers one has Local Server and Another One is WEB Server...The Entries will be directly Stored in LOcal Server Only(bcoz Some times have Internet Connection Problem)...Now what can i do Mean, How can i update recodrs(Daily Entry Records Only) from local server to Webserver table (Daily Update or Hours Based Update)..
If u have any idea about Automatic update Process is More Better...Thanks in Advance.....

解决方案

If the databases are true copy in local and web server you can synchronize them as per comment provided by "ThePhantoomUpvoter" in the question above else, you may need to run a timer that runs at a regular interval and update the data from local server to web server.

To simplify things, you can add a "isWebUpdated" field in your local DB and set it to Zero at every insert. Once the data is updated to web server, update this field to 1.

这篇关于将SQL表记录从本地服务器更新到WebServer的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！