Menu
Hi from so many days im searching about this topic but unable to get a hint also. if any one know how to sync sqlite data to sql server using cordova and javascript please help out
532
To Fetch values into Database Table in sqlite using Cordova plugin. In this method we fetch data from the database by using select query and using res.rows.item () we are displaying the database values in alert boxes. To Drop Table into Database in sqlite using Cordova plugin. To Update values into Database Table in sqlite using Cordova plugin.
These are the steps we will follow: Download an ODBC driver for SQLite. Install the driver. Create a System DSN for the database. Create a linked server in SQL Server. Select the data from the source and insert it into a SQL Server database table.
You have data in SQLite databases on mobile devices you would like to import into SQL Server. In this tip we walk through the steps on how to import this data into SQL Server.
Use CData Sync for automated, continuous, customizable SQLite replication to SQL Server. Always-on applications rely on automatic failover capabilities and real-time data access.
Open source implementations
There are some open source projects for syncing the PhoneGap app with the remote server. But you will have to adjust/implement to fit your project.
Synchronize a local WebSQL Db to a server
Couchbase Lite PhoneGap plugin
Pouchdb
Alternativly, custom API
You could create your own set of API methods to send / update data from the WebSQL to your remote server DB. Flagging records that need to 'sync' to the external server. But you'll have to take measurements for a large bit of logics if the sync process is 2 way (central server - app - central server).
Since your question limits the amount of information it's hard to help out with more detailed information in this stage.
170
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
