从sql server表到另一个sql server表的数据同步 [英] Data synchronisation from sql server table to another sql server table

问题描述

大家好，
我需要的是我有一台具有sql服务器表(如提供程序和产品)的服务器，我想要的是从此服务器获取这些记录，并通过使用DataTable进行编码将其放在另一台服务器上?任何的想法 ?
提前致谢.

Hello all,
what i need is that i have an server which have an sql server tables ( like providers and products ) what i want is to get these records from the this server and put it on another server by coding using DataTable ? any idea ?
Thanks In Advance.

推荐答案

您可以通过编写将值插入该服务器的SQL将其放在其他服务器中.它还能如何工作?这与HTML5无关，与您的后端代码有关，这听起来像是在两个数据库之间共享数据.因此，除非您绝对需要它们保持同步，否则我将在服务器上运行一项服务，以每晚从一台服务器向另一台服务器上载数据，在这种情况下，我会问为什么?

You put it in the other server by writing SQL that inserts the values in to that server. How else could it work ? This has nothing to do with HTML5, it has to do with your back end code, which sounds like it is sharing data between two databases. As such, I''d run a service on the server to do a nightly upload of data from one server to the other, unless you absolutely need them to be in synch, in which case I''d ask, why ?

这篇关于从sql server表到另一个sql server表的数据同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！