数据库同步逻辑 [英] Database Synchronization Logic

问题描述

我想制作/使用现有的框架，用于同步具有大量数据的应用程序数据库。每个应用程序中的数据库都是sql server。

你能告诉我我的方法是什么吗？



例如我有4个不同的应用程序sql server数据库（所有大数据）。我要做的最终事情是提供MDM，一个同步的主数据库。

那么，是否有任何工具或框架可以帮助我创建一个公共数据库，它将在插入，更新，删除操作上同步特定实体和属性的数据。

I want to make / Use existing Framework which is used to sync Application database having Large amount of data. Database in each application is sql server.
Can you suggest me what shall be my approach?

For example I have 4 different applications having sql server database(All large data). Ultimate thing I have to do is to provide MDM , A synchronized master database.
So, Is that any tool or Framework which can help me to make a common database which will sych data of particular entity and attributes on Insert, update, delete operations.

推荐答案

当你得到这样的大主题查询时，要做的第一件事就是从谷歌开始：数据库同步 [ ^ ]如果您可以在那里找到解决方案，或者至少消除一些选项以使问题更小并且更负责 。看看一些链接，看看哪些适合你的情况 - 有很多选项可能是你想要实现的，我们在这个阶段建议的任何东西几乎肯定是错的！ ：笑：

When you get a "big subject" query like this, the first thing to do is to start by looking at Google: "database synchronization"[^] and trying to work out if you can either find a solution there, or at least eliminate some options to make the question smaller and "more answerable". Have a look at some of the links, and see what fits your circumstances - there are so many options that could be what you are trying to achieve that anything we suggest at this stage is almost certainly wrong! :laugh:

如果您想获得如何提供MDM的一些说明，请看这里：

主数据管理的内容，原因和方法 [ ^ ]

主数据管理（MDM）集线器架构 [ ^ ]

If you want to get few instructions how to provide MDM, please, take a look here:
The What, Why, and How of Master Data Management[^]
Master Data Management (MDM) Hub Architecture[^]

这篇关于数据库同步逻辑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！