如何在sqlite和远程ms sql server之间同步 [英] How to sync between sqlite and remote ms sql server

问题描述

任何人都可以告诉我如何在sqlite和ms sqlserver之间同步数据，反之亦然。

can anybody tell me how to sync data between sqlite to ms sqlserver and also in vise versa.

推荐答案

据我所知，你必须要么写自己同步或使用第三方工具。如果你对这些工具感兴趣，有几种可能性。



例如：

- SQLITE-SYNC [ ^ ]。他们似乎有一个免费版本

- SQLite到MSSQL同步 [ ^ ]。这需要获得许可



另一方面，您可以考虑在两端使用SQL Server吗？这将使同步变得更加容易。如果您在客户端需要单个用户独立数据库，则可能 SQL Server Compact [ ^ ]可以替换SQLite。

As far as I know, you have to either write the synchronization yourself or use a 3rd party tool. There are a few possibilities if you're interested on those tools.

For example:
- SQLITE-SYNC[^]. They seem to have a free version
- SQLite to MSSQL Synchronization[^]. Thiss one needs to be licensed

On the other hand perhaps you could consider using SQL Server on both ends? This would make the synchronization far more easy. If you need a single user standalone database on the client side, then perhaps SQL Server Compact[^] could replace SQLite.

请设计以下内容以在SQLite和远程服务器之间同步数据



1.运行后台服务

2.上述背景将调用Web服务端点以从远程服务器获取所有详细信息（响应可能是JSON或XML）

3.解析JSON或XML数据

4.在SQLite数据库中保存已解析的详细信息



谢谢

Please design the following to sync data between SQLite and Remote server

1. Run a background service
2. The above background will call a web service end point to get all details from remote server (Response may be JSON or XML)
3. Parse the JSON or XML data
4. Save the parsed details in SQLite database

Thank You

这篇关于如何在sqlite和远程ms sql server之间同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！