如何比较两个不同数据库的模式和数据 [英] How to compare schema and data of two different databases

问题描述

how to compare schema and data of two different databases and synchronize the latest changes in target database through c shrap Code. Note: i'm working on Desktop Application with Sql Server 2014

Explanation: i'm working with Desktop application on visual studio 2013 and sql server 2014. i want my application to work with local database, but after a specific time i want to sync new entries OR new schema changes in remote database having the exact same schema as local database. I want solution in c# code. may be stored procedure can also helpful.

我尝试过：



没有找到有用的物资

What I have tried:

nothing helpful materiel found yet

推荐答案

获取整个数据库的模式（我非常怀疑你真正想要的）需要相当多的规划和代码，特别是如果您还想获得与该数据库关联的所有相关数据库组件。你的问题的答案是在问答范围之外的WHOLLY。



而不是要求我们为你做，不要自己动手，当你遇到困难时，请回到这里，找到给你问题的代码，并询问一下那个问题。

Getting a schema for an entire database (which I seriously doubt is what you really want) requires quite a bit of planning and code, especially if you also want to get all of the related database components associated with that database. The answer to your question is WHOLLY outside the scope of a Q&A question.

Instead of asking us to do it for you, do it yourself and when you get stuck, come back here with the code that is giving you problem, and ask about that single problem.

这篇关于如何比较两个不同数据库的模式和数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！