同步数据库 [英] Synchronizing databases

问题描述

我开发一个将数据存储在本地使用SQLite数据库Adobe AIR应用程序。 在任何时间，我想在最终用户到他/她的本地数据同步到中央MySQ​​L数据库。

I am developing an Adobe AIR application which stores data locally using a SQLite database. At any time, I want the end user to synchronize his/her local data to a central MySQL database.

任何提示，建议为获得这项权利？ 性能稳定是关键（除了安全性;））

Any tips, advice for getting this right? Performance and stability is the key (besides security ;))

推荐答案

如果你只是从服务器到客户端的同步中，叶兰的解决方案应该工作。

If you're just sync'ing from the server to client, Eran's solution should work.

如果你只是从客户端到服务器的同步中，只是扭转它。

If you're just sync'ing from the client to the server, just reverse it.

如果您正在同步中左右逢源，有乐趣。你会在最短可能想保留更改日志，您将需要弄清楚如何处理冲突。

If you're sync'ing both ways, have fun. You'll at minimum probably want to keep change logs, and you'll need to figure out how to deal with conflicts.

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