从sqlite android获取数据并将其存储到SQL服务器，反之亦然 [英] Get and store data from sqlite android to SQL server and vice versa

问题描述

Hi Team，



我们有一项要求，要求是



我们的分包商有一个他们嵌入移动设备的硬件设备。他们使用一个应用程序从标签读取数据并将数据保存到移动设备中的sqlite数据库。



我们的要求是每当数据插入sqlite数据库表中时事务我们需要获取相同的数据并需要放在我们的本地sql server数据库中。



在我们的数据库中存储数据之后，我们使用我们的前端生成报告应用程序，在我们的前端应用程序中，我们提供一些屏幕来注册详细信息，当我们注册详细信息时数据保存在我们的本地sql server db中，当数据插入我们的数据库时，数据再次需要发送回sqlite android db。 br />


简单来说，需要从sqlite android中检索数据并需要放在本地sql server中并将存储在本地sql server中的数据发送到sqlite android db和vice对于每笔交易都是如此。



这里交易将每1秒发生一次，如果有任何教程，我们如何执行此操作o可以提供给我的文件。



我在google上做过R& D但我找不到任何解决方案，从哪里开始。



我们对这种情况完全不熟悉。



我的尝试：



R& D在google中获得更好的解决方案但没有用我根据我们的要求找不到任何解决方案。

解决方案

我会对Richard的主题略有不同。



让我们来看看Android



1）Sqlite触发器将数据插入复制表

2）服务定期扫描复制表并检查数据 - 如果有的话，发送到SQL Server上的REST服务

3）服务也托管REST接口 - 收到数据（来自SQL服务器） ）进入SQLite数据库



在SQL Server上，服务是一样的 - 显然它是b / b $ 1监视SQL服务器中的复制表通过REST向Android发送数据

2）从Android接收REST数据并输入SQL Server DB



您还可以用协议替换REST缓冲器

Hi Team,

We have one requirement, the requirement is

our subcontractors have one hardware device in that device they embedded mobile. They are using one application to read data from tag and saving that data to sqlite database in mobile.

Our requirement is whenever data is inserted in their sqlite database tables for every transaction we need to take same data and need to place in our local sql server database.

After storing data in our database, we are generating reports by using our front end application, in our front end application we are providing some screens to register details, when we register details the data saves in our local sql server db, when ever data inserts in our db that data again need to send back to sqlite android db.

To be simple, need to retrieve data from sqlite android and need to place in local sql server and send data which is stored in local sql server to sqlite android db and vice versa for every transactions.

here transactions will occur every 1 second, how can we perform this, if any tutorials or documents available please suggest me.

I did R&D in google for lot but I didn't find any solution and where to start.

we are completely new to this scenario.

What I have tried:

Did R&D in google for better solution but no use I didn't find any solution according to our requirement.

解决方案

I would do a slight variation on Richard's theme.

Lets look at Android

1) Sqlite trigger inserts data into replication table
2) service scans replication table periodically and checks for data - if any available, sends to REST service on SQL Server
3) service also hosting REST interface - on receipt of data (from SQL server) enters into SQLite Database

On SQL Server, the service is the same - obviously it
1) monitors a replication table in SQL server sending data to Android via REST
2) receives REST data from Android and enters in SQL Server DB

you could also replace REST with protocol buffers

这篇关于从sqlite android获取数据并将其存储到SQL服务器，反之亦然的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！