如何将数据从在线数据库传递到本地数据库 [英] How to data pass from online database to local database

问题描述

如何将数据从在线数据库传递到本地数据库



我尝试过：



如何将数据从在线数据库传递到本地数据库

解决方案

这不是一个简单的主题 - 它非常复杂，非常非常快。



问题是从远程数据库获取信息很容易 - 但数据库不是静态的东西，它们会得到更新。添加本地数据库的主要原因是本地副本可以脱机使用 - 以及在本地数据库上更新的数据会发生什么？它是否应该在远程数据库上更新？如果其他人也更新了相同的数据 - 哪一个应该赢呢？



这是一个叫做数据库复制的问题，你需要在进入它之前仔细思考：你的数据库必须非常仔细地设计并具体规则在您开始尝试编码之前建立。

请在此处阅读：复制（计算） - 维基百科 [ ^ ]然后按照几个链接：

数据库复制 - Google搜索 [ ^ ]

数据库复制与对帐 [ ^ ]

how to data pass from online database to local database

What I have tried:

how to data pass from online database to local database

解决方案

This is not a simple subject - it gets to be extremely complicated, very, very quickly.

The problem is that getting info from a remote DB is easy - but databases aren't static things, they get updated. And the main reason for adding a local database is so that the local copy can be used "offline" - and what happens to data that is updated on the local DB? Should it be updated on the remote DB as well? And what if someone else also updated the same data - which one should "win"?

This is a problem called Database Replication and you need to think long and hard before you leap into it: your DB(s) must be designed very carefully and specific rules established before you even start trying to code.
Have a read here: Replication (computing) - Wikipedia[^] and then follow a few links:
Database Replication - Google Search[^]
database replication and reconciliation[^]

这篇关于如何将数据从在线数据库传递到本地数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！