CODEWITHSUNDEEP
apache-flexsqliteflex3
DaveC
DaveC

Reputation: 552

Using Flex to keep local SQLite database in sync with live server database

I want to create a Flex 3 application running in Adobe Air that accesses an SQLite database and I need to keep this database in sync with an SQL server 2005 database running a website.

Is this something that Flex supports or is it going to be a custom script? Also, has anybody done anything like this?

Edit: The synchronisation can be done on a daily basis rather than real time. The data will be read only from a front end perspective with a CMS to do updates on the website.

Upvotes: 2

Views: 1450

Answers (2)

Cornel Creanga
Cornel Creanga

Reputation: 5308

LCDS has a lot of features and yes it is expensive - if you only need the offline support it is overkill. There are some tools which can be used to synchronize two databases but I do not know if they support SQLite..if not you will have to write it yourself.

Upvotes: 1

Gregor Kiddie
Gregor Kiddie

Reputation: 3119

Take a look at LCDS and it's offline support with Flex.

Basically it means running all your code through managed data services, which keeps the SQLite DB in sync.

Warning... LCDS is very, very expensive.

Upvotes: 0

Related Questions