Great Addin For SQL CE (Synchronization)

Thread is closed for posting
2 posts, 0 answers
  1. Garry
    Garry avatar
    205 posts
    Member since:
    Nov 2010

    Posted 18 May 2010 Link to this post

    If you are doing any type of disconnected app and are using SQL CE as your local DB store then here is a very nice addin I have been using.

    http://exportsqlce.codeplex.com/

    The problem this solves is that when you synchronize your local database cache with your master DB it does not pull over relationships between tables and thus OpenAccess doesn't know to generate the child fields for those related tables. What you can do however is reestablish your relationships on the CE DB, pain I know, and then use this addin to script out those relationships. That way whenever you need to add or remove tables to your local DB cache and the relationships you setup are blown away you can simply run the exported script against your CE db and boom relationships are back. 

    Huge time saver. Anyhow I was delighted to have found this and thought I'd share.  
  2. Alexander
    Admin
    Alexander avatar
    727 posts

    Posted 19 May 2010 Link to this post

    Hi Garry,

    Yes, it seems helpful. Thanks for sharing it with us.

    Regards,
    Alexander
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Back to Top