wan中两个sql server之间的sycn数据 [英] sycn data between two sql server in wan
问题描述
大家好,
i在WAN环境中拥有相同的数据库和两个不同的服务器,如果有任何变化让一个数据库sample_table变得愉快,我想sycn那个sample_table数据'' s到其他数据库,
i使用除了kyeword来查找两个表之间的差异,但是它花了太长时间来执行。所以我的表有大量数据
这是我的查询
select * from server_1.db_name.sample_table
除外
select * from server_2.db_name.sample_table
您可以复制数据库,您的服务器将为您完成这项工作。 />
SQL Server复制
hi all,
i have same database with tow diffrent server in WAN environment, if any changes happnd one database sample_table,i want to sycn that sample_table data''s to other database,
i am using except kyeword to find diffence between two tables,but its taking too long time to excute.also my table has huge data
this is my query
select * from server_1.db_name.sample_table
except
select * from server_2.db_name.sample_table
You could replicate your database and your server will do this job for you.
SQL Server Replication
这篇关于wan中两个sql server之间的sycn数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!