如何比较来自不同数据库和不同实例的表之间的差异?如果有则如何复制? [英] how to compare difference between table from different database and different instance ?if it having then how to copy ?

问题描述

1)源实例=>源数据库=>源表
2)目标实例=>目标数据库=>目标表
检查链接的服务器并将差异数据复制到源"表中?
什么是解决方案??

1)sourece instance=>source database=>sourece table
2)Destination instance=>destination database =>destination table
Check with linked server and copy difference data to Source table??
what is solution ??

推荐答案

最明显的解决方案是购买类似 ^ ]，如果您只需要执行一次，则使用试用版.话虽如此，在服务器之间运行SQL并不难.您可以在此处 [ ^ ]. SSIS [

The most obvious solution is to buy a program like Sql data compare[^], or use the trial if you only need to do this once. Having said that, it''s not hard to run SQL between servers. You can read up on how to do that, here[^]. SSIS[^] is another option.

这篇关于如何比较来自不同数据库和不同实例的表之间的差异?如果有则如何复制?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！