Synchronize CE database to SQL at cradle

Posted on 2007-07-31
Last Modified: 2013-12-27
Hi Experts,
I have a client that uses palms to track inventory of shipments that come and leave their  warehouse; when they cradle the Palm it synchronizes with an MS Access Database.  The client has a corporate headquarters and (6) remote warehouses; they want to migrate to SQL rather than Access.  I am charged with developing an application that does just this.  What is my best approach, I have never developed for CE before so this is all new territory.
I would assume that the CE database would reside on the palm at publishing and when cradled would send everything to the local SQL database and purge the tables of the CE database on the Palm.  What is the best means of attacking this project?
How can I get the table structure and the data from the current access database (or from SQL 2005) into the CE database of the palm?  

Thanks for your assistance
Question by:NCSO
    LVL 48

    Accepted Solution

    you can import from SQL Server 2005 and then just export to ce

    Author Comment

    Thanks for your assistance

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Preface: This article is part of a series focused on cross platform mobile app development (specifically Android and iOS) using the Alloy framework and Titanium Studio made by Appcelerator ( This article presumes a wor…
    If you are anything like me, you install many apps on your phone and have your life on it, sometimes literally.  When I bought my current phone, a Samsung Galaxy S5 from Verizon, they were only selling the versions with 16 GB internal.  I didn't rea…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now