INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Mimer and synchronization from PocketPC?

Mimer and synchronization from PocketPC?

(OP)
Hi.  I'm interested in using Mimer SQL as an embedded database in applications on WinXP and PocketPC.  I've been searching through the documents, but the only reference I've seen to synchronizing tables between the two says something like, "For synchronization ActiveSync is recommended."

I was wondering how this actually worked.  Do you have to write your own synchronization code?  What sort of support does Mimer have built in?  If there's a document about this, please point me at it.

And -- is there any intention to include PalmOS in the list of platforms that Mimer runs on?

Thanks.

  Vik

RE: Mimer and synchronization from PocketPC?

There is no built-in replication (if that is what you are looking for). However, it is really easy to write a really simple application that transfers changes from the PDA database to/from a central database. This application can run either on the PDA or on machine that hosts the database (or anywhere else that is suitable).

RE: Mimer and synchronization from PocketPC?

(OP)
MimerWizard,

Thanks for the info.  Are there any examples of such code anywhere, of the simple synchronization application you spoke about?  I'd be grateful for any pointers, so before I start building my databases I can be aware of any design requirements for the tables and so on.

I imagine this must be a fairly common requirement for database programmers nowadays, so maybe there are other examples of the general principles elsewhere.  I found an article on devx.com which talked about exposing .NET datasets through web services, which could then be used to merge additions.  But it didn't say much about handling deletions and updates.

Anyway, I'd be grateful for any general or specific ideas.

  -- Vik

RE: Mimer and synchronization from PocketPC?

I do not know of any examples. Replication for a specific case is usually not difficult to handle.

Basically, all you need to do is have an extra column that you update whenever you change the data. This column can then be used to find the rows that should be moved back to the central database.

The easiest way is to use procedures for your insert, update, and delete operations. In the procedures you handle the update of the extra column. In the case of delete you keep the row until it has been deleted in the central database. For select operations you would construct a view that does not return the deleted rows.

Hope this helps!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close